Re: Select one field/value from two different tables

From: Dan Blum <>
Date: Tue, 5 Aug 2008 17:06:31 +0000 (UTC)
Message-ID: <g7a1an$38h$>

JBond007 <> wrote:
> On Aug 4, 7:12?pm, (Dan Blum) wrote:
> >
> > I'm amazed that that actually parses.

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

Either solution provided should work fine. If you provide the complete statement with eithre of those included, someone can probably figure out what the problem is - it's likely you just have the syntax slightly wrong somewhere.

Dan Blum					
"I wouldn't have believed it myself if I hadn't just made it up."
Received on Tue Aug 05 2008 - 12:06:31 CDT

Original text of this message