Re: Select one field/value from two different tables

From: gazzag <>
Date: Tue, 5 Aug 2008 07:50:55 -0700 (PDT)
Message-ID: <>

On 5 Aug, 15:14, JBond007 <> wrote:
> .....I got the same response from some other programmers in my
> company,
> .....including a DBA who, unfortunately, doesn't know code.
> .....Unfortunately, what worked in SQLPlus, from my original msg,
> doesn't work in Pro*C,
> .....which complains about the word "oldschool" in the larger query's
> concatentation.
> .....Neither SQLPlus nor Pro*C liked the union in the sub-select or
> the word "coalesce",
> someone else's response.
> .....I also tried if, case, and decode, to no avail (they worked, but
> didn't give me what I wanted.
> .....I can't believe this is as complicated as it seems!

The last line in that post indicates to me that your logic and/or design is flawed. Not terribly helpful to you, sorry, but design might be worth a re-think.

HTH -g Received on Tue Aug 05 2008 - 09:50:55 CDT

Original text of this message