Re: need help converting oracle outer joins into ansi compliant sql
Date: Sat, 10 Feb 2001 17:03:46 GMT
Message-ID: <3a857469.3749211_at_news.online.de>
The (+) is a "LEFT OUTER JOIN"
eg.
select a.name,b.condition
from a left outer join b on a.id=b.condition
Ted
On Thu, 8 Feb 2001 00:23:53 +0300, "Sergey Sugak" <ssouguck_at_mail.wplus.net> wrote:
>
>"Jae Kim" <jkim_at_businessobjects.com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
>news:95meh8$ftl$1_at_news.businessobjects.com...
>> ansi sql experts,
>>
>> i am trying to convert the following Oracle sql statement into ansi sql
>> compliant statement. any help would be appreciated. Thanks in advance!
>>
>> select a.name,b.condition
>> from a, b
>> where a.id=b.condition_id(+)
>>
>> Jae Kim
>>
>>
>>
>
>Use union instead of (+)
>
>where exists
>union
>where not exists
>
>
EMail: knijff_at_bigfoot.com Received on Sat Feb 10 2001 - 18:03:46 CET