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 CEST