Creating Views on Multiple Identical Tables

Hey folks, Is there a way to create a view on a group of tables that have identical col. names? The tables contain data from the 4 quarters of the year, ie: ba01_96q1 ba01_96q2 ba01_96q3 ba01_96q4 etc... I need to create a view that contains the data from all the tables, however the following statement errors out: create view ba01_all as select * from ba01_96q1, ba01_96q2, ba01_96q3, ba01_96q4. Is there a way to do this, or am I out of luck? David J. Hinkle Systems/Database Administrator email: dhinkle@firstam.com First American Credco Voice: (619) 929-6000 x6247 5927 Priestly Drive Ste 250 Fax: (619) 929-6011 Carlsbad, CA 92008 --------------------------------------------------------------------------- Why ask Why: Why are there flotation devices under plane seats instead of parachutes? ---------------------------------------------------------------------------