Re: Going mad - outer join problem
Date: Mon, 20 Oct 2008 10:08:18 +0100
In article <48FB79A2.7010505_at_gmail.com>, mdemenko_at_gmail.com says...>
> select *
> from a,
> 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