Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: outer join

Re: outer join

From: Valery Yourinsky <vsu_at_bill.mts.ru>
Date: Fri, 12 Jan 2001 13:29:03 +0300
Message-ID: <3A5EDC6F.D8222BE@bill.mts.ru>

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 DBA
Received on Fri Jan 12 2001 - 04:29:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US