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_at_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.

"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 CEST

This message: [ Message body ]
Next message: Bob Fazio: "Re: ORA-01157"
Previous message: matt mcConnell: "Re: Pro*C/C++ - How do I OPEN CURSOR and FETCH in different fucntions"
In reply to: Rayfil Cheung: "Select a-row alternative from several tables one-by-one until found"
In reply to Rayfil Cheung: "Select a-row alternative from several tables one-by-one until found"
Next in thread: Bob Fazio: "Re: ORA-01157"
Reply: Rayfil Cheung: "Re: Select a-row alternative from several tables one-by-one until found"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message