Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Getting similar data

Re: Getting similar data

From: Steve Wood <jester98x_at_btinternet.com>
Date: Mon, 7 Jan 2002 08:01:49 +0000 (UTC)
Message-ID: <a1bkld$khl$1@knossos.btinternet.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US