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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Selecting data from 2 similar tables

Re: Selecting data from 2 similar tables

From: Richard Armstrong <richard.armstrong_at_juno.demon.co.uk>
Date: Wed, 16 Aug 2000 15:34:11 +0100
Message-ID: <966436811.9910.1.nnrp-13.9e9809ca@news.demon.co.uk>

Could you use two selects joined with UNION ?

Regards,

Richard

Joseph Ranseth <jransethNO_SPAM_at_worldcupfishing.com> wrote in message news:0lxm5.1338$ak3.11104_at_news1.mts.net...
> I have 2 tables with similar data, and I need to get the rows from each.
>
> They are almost identical, they are NOT joined, or related, they just
> contain similar data. How can I get values from both, without having to
> merge the two tables?
>
> Is this clear enough?
>
> Thanks in Advance.....
>
> JR
> --
>
>
Received on Wed Aug 16 2000 - 09:34:11 CDT

Original text of this message

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