Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL - View with two tables?
Look up the syntax for UNION.
hth
Anthony Hogan
Xaver Trapichler wrote:
>
> Hi,
> I have two tables with the same column-structure,
> I need a view including all data of the two tables ...
>
> create view
> select * from table1, table2
> --> This command creates one row with data
> of table1 and table2, then the next row with
> data of table1 and table2 ...
> result:
> <data table1> <data table2>
> <data table1> < data table2>
> ...
>
> I need a view where there are all rows of
> table1 and all rows of table2 (the column-structure of the tables is the
> same)
> result:
> <data table1>
> <data table1>
> <data table2>
> <data table2>
> ...
>
> Thanks for your answer in advice ...
> Xaver
Received on Wed May 28 2003 - 02:11:16 CDT