Re: need help converting oracle outer joins into ansi compliant sql
From: Sergey Sugak <ssouguck_at_mail.wplus.net>
Date: Thu, 8 Feb 2001 00:23:53 +0300
Message-ID: <95sees$r7v$1_at_news.wplus.spb.ru>
Date: Thu, 8 Feb 2001 00:23:53 +0300
Message-ID: <95sees$r7v$1_at_news.wplus.spb.ru>
[Quoted] "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
Received on Wed Feb 07 2001 - 22:23:53 CET