Re: Going mad - outer join problem

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?

-- 
jeremy