Re: SQL QUERY

Hi,

 you should create a view like thid :

create or replace view view_name ase
select a,b,c
from tab1
union all
select a,b,c
from tab2
union all
=2E.
=2E.

Davide

-----Original Message-----
From: Suhen Pather PatherS5_at_telkom.co.za Sent: Mon, 04 Sep 2000 07:50:20 -0800 To: ORACLE-L_at_fatcity.com
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 =20
COL1 COL2 COL3 COL4=20

blah      blah     blah      blah
abcd    defg     jfjfkjf      xyz

TABLE2=20
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=20

VIEW1

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

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).



_________________________________________________________________________=
__
Visit http://www.visto.com/info, your free web-based communications cente=