Re: Going mad - outer join problem
From: Jeremy <jeremy0505_at_gmail.com>
Date: Mon, 20 Oct 2008 10:08:18 +0100
Message-ID: <MPG.23665ada8d94c88198968a@News.Individual.NET>
Date: Mon, 20 Oct 2008 10:08:18 +0100
Message-ID: <MPG.23665ada8d94c88198968a@News.Individual.NET>
In article <48FB79A2.7010505_at_gmail.com>, mdemenko_at_gmail.com says...>
> select *
> from a,
> b
> where a.id = b.id (+)
> and nvl(b.code(+),'TYPE') = 'TYPE'
> order by a.id;
>
is the right answer. Thanks and also to David and Serge for their help.
When I was taught SQL by oracle I don't recall there ever being references to e.g. "LEFT OUTER JOIN" - it was all the (+) notation.
I guess they are methods to achieve the same objective but what are the pros and cons?
-- jeremyReceived on Mon Oct 20 2008 - 04:08:18 CDT