Re: Getting similar data

Steve,

Thanks for the help, that worked exactly the way I needed.

Cheers,
Steve

"Steve Bell" <stephenb_at_sympatico.ca> wrote in message news:_s0_7.3441$os5.269708_at_news20.bellglobal.com...
> Hi,
>
> If I understand your question correctly, just use a UNION query, like
this:
>
> SQL> select * from table1;
>
> THINGY1 NUM1 NUM2
> ---------- ---------- ----------
> apple 2 98
> pear 5 100
>
> SQL> select * from table2;
>
> THINGY2 NUMA NUMB
> ---------- ---------- ----------
> gun 20 300
> lolly 3 150
>
> SQL> select * from table1
> 2 union
> 3 select * from table2;
>
> THINGY1 NUM1 NUM2
> ---------- ---------- ----------
> apple 2 98
> gun 20 300
> lolly 3 150
> pear 5 100
>
> SQL>
>
> I hope this helps,
>
> Steve
>
>
Received on Mon Jan 07 2002 - 02:01:49 CST