UNION ???
select * from tab1
UNION
selcect * from tab2;
"Tim" <tim.bedford_at_ttplabtech.com> wrote in message
news:daf29ce0.0201090615.268de3f_at_posting.google.com...
> Hi,
> Is it possible to create a view that is a vertical concatenation of
> two or more tables? In other words, say you've got two tables created
> with:
>
> CREATE TABLE TAB1(VALUE1 VARCHAR2(10));
> CREATE TABLE TAB2(VALUE2 VARCHAR2(10));
>
> And you want a view with one column containing all the values of both
> tables.
> (I vaguely remember looking into this a while ago and concluding that
> it couldn't be done, someone prove me wrong).
> thanks,
>
> Tim
Received on Fri Jan 11 2002 - 11:19:10 CST
