Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: outer join
Christopher wrote:
>
> Outer Join Syntax for Oracle :
> SELECT ....WHERE a = b (+) ...
>
> Outer Join Synatx for Microsoft SQL :
> SELECT ....WHERE a =* b ...
>
> Is there any generic sql statement that do outer join for Oracle, Sybase and
> Microsoft SQL Server?
No.
Only In the future Oracle9i will support ANSI compliant joins.
Valery Yourinsky
-- Oracle8 Certified DBAReceived on Fri Jan 12 2001 - 04:29:03 CST
![]() |
![]() |