combining rows from 2 tables

[jt]

Is there a way to create a view that combines all rows from 2 tables
that have the same columns/fields?

thanks,
Judi

[osy45]

create view <view> (col1, ... col<n>) as

select col1, ... col<n> from tab1

union

select col1, ... col<n> from tab2

/
--
Posted via http://dbforums.com

[Jan]

SELECT col1, col2 ...
FROM table_A
UNION
SELECT col1, col2 ...
FROM table_B

[sybrandb]

ju**********@yahoo.com (jt) wrote in message news:<6f**************************@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

[Guido Konsolke]

"jt" <ju**********@yahoo.com> schrieb im Newsbeitrag
news:6f**************************@posting.google.c om...

Is there a way to create a view that combines all rows from 2 tables
that have the same columns/fields?

thanks,
Judi

Hi Judi,

minor addition to what 'osy45' and Sybrand wrote:
performance will be better if you make it a
UNION *ALL*.

Greetings,
Guido