Re: Going mad - outer join problem

"Jeremy" <jeremy0505_at_gmail.com> wrote in message news:MPG.23665ada8d94c88198968a_at_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?
>
> --
> jeremy

Oracle has had the ISO join syntax since version 9i. The ISO syntax is a standard used by almost all other DBMSs whereas the (+) syntax is peculiar to Oracle. The ISO syntax also supports FULL OUTER JOIN for which there is no simple equivalent in the older Oracle syntax.

-- 
David Portas