Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Select a-row alternative from several tables one-by-one until found
Hi friend,
Thank you for your advice. Sorry for my vague mind. The searched value(row) may be stored in one or many tables. The searched tables are given the priority. Once the value(row) is found, no further tables are needed to be searched.
Thanks & Regards,
Rayfil.
MyTwoBits wrote:
> 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 Tue May 30 2000 - 00:00:00 CDT