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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle outer join syntax (+) not working???

Re: Oracle outer join syntax (+) not working???

From: David Portas <REMOVE_BEFORE_REPLYING_dportas_at_acm.org>
Date: 17 Jun 2006 15:28:50 -0700
Message-ID: <1150583329.962414.30940@r2g2000cwb.googlegroups.com>


DA Morgan wrote:
> David Portas wrote:
>
> >> You might note that this operator also exists in Sybase and SQL Server.
> >> It is not just an Oracle syntax.
> >
> > Not in Microsoft SQL Server and I'm pretty....
>
> Most certainly.
>
> http://msdn2.microsoft.com/en-us/library/ms165317.aspx

For the avoidance of doubt, what this means is that the (+) syntax is NOT allowed in Microsoft SQL Server (and never has been to my knowledge).

-- 
David Portas
Received on Sat Jun 17 2006 - 17:28:50 CDT

Original text of this message

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