Re: combining rows from 2 tables
From: <sybrandb_at_yahoo.com>
Date: 18 Sep 2003 03:09:34 -0700
Message-ID: <a1d154f4.0309180209.1c32152b_at_posting.google.com>
Date: 18 Sep 2003 03:09:34 -0700
Message-ID: <a1d154f4.0309180209.1c32152b_at_posting.google.com>
judiphuongtu_at_yahoo.com (jt) wrote in message news:<6f38222f.0309172047.111558b6_at_posting.google.com>...
> Is there a way to create a view that combines all rows from 2 tables
> that have the same columns/fields?
>
> thanks,
> Judi
create view blah as
select *
from table1
union
select *
from table2
Performance will be disastrous.
Please reconsider the design
Sybrand Bakker
Senior Oracle DBA
Received on Thu Sep 18 2003 - 12:09:34 CEST