Re: SQL QUERY

Hi,

create view table as (
select col1,col2,col3,col4 from table1
union
select col1,col2,col3,col4 from table2 );

ravindran

• Original Message ----- From: Suhen Pather <PatherS5_at_telkom.co.za> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Monday, September 04, 2000 8:50 AM Subject: SQL QUERY

Hi Gurus

I require help with creating a view based on multiple tables. There are 22 tables that have the same column names. I need to create a view based on these tables so that each of the tables data is appended to the view.

eg TABLE1
COL1 COL2 COL3 COL4

blah      blah     blah      blah
abcd    defg     jfjfkjf      xyz

TABLE2
COL1 COL2 COL3 COL4

what     is          my         name
where   do         I            work

If I combine the 2 tables into a view it must look like

VIEW1

COL1         COL2       COL3       COL4
blah           blah         blah         blah
abcd         defg         jfkjf           xyz
what           is             my           name
where         do           I               work

Any help would be greatly appreciate

TIA Suhen Pather
Oracle DBA (OCP)
Telkom SA
Land +27 12 300 4025
Mobile +27 82 770 9801

--
Author: Suhen Pather
  INET: PatherS5_at_telkom.co.za

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).