Re: Select one field/value from two different tables

JBond007 <nafis121_at_yahoo.com> wrote:
> On Aug 4, 7:12?pm, t..._at_panix.com (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",
> .....in 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					         tool_at_panix.com	
"I wouldn't have believed it myself if I hadn't just made it up."