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: Select a-row alternative from several tables one-by-one until found

Re: Select a-row alternative from several tables one-by-one until found

From: MyTwoBits <nighr_at_hotmail.com>
Date: 2000/05/29
Message-ID: <pMAY4.98606$fF5.3127977@news1.rdc1.il.home.com>#1/1 






I think the reason why no one is responding is that your question is too
vague.  If you are looking for a value from many tables, you will need a
UNION statement with your WHERE clause.



My25/c.





"Rayfil Cheung" <rayfil_at_forward-hk.com> wrote in message
news:392CC5F5.73ACA149_at_forward-hk.com...


> Can some help me how write a single SQL or sorts of SQL statements that

> can select a row (value) alternative from several tables one by one

> until the row (value) is found.  Thanks in advance.

>

>

Received on Mon May 29 2000 - 00:00:00 CDT












Original text of this message













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