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

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Sun, 18 Jun 2006 07:59:01 -0400
Message-ID: <x8Kdndf1j7yW3QjZnZ2dnUVZ_qednZ2d@comcast.com>

"David Portas" <REMOVE_BEFORE_REPLYING_dportas_at_acm.org> wrote in message news:1150583329.962414.30940_at_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
:

dan's link caught my attention as i had not remembered (+) in MS-SS, and indeed could not find any other references. so, good call on clarifying that.

however, i found this interesting comment when doing my research (from http://msdn2.microsoft.com/en-us/library/zt8wzxy4.aspx)

      "Note
      Some databases, such as Oracle, do not support full outer joins. "

      I guess there's no FUD like old FUD.

      ++ mcs

begin 666 zt8wzxy4.note(en-US,VS.80).gif M1TE&.#EA"@`*`+,)`/\$`/]=6L;#QM;3UO_/`(2&A(R.C ```/__SO___P``

M`````````````````````"'Y! $```D`+ `````*``H```0HT,@Y1 `&Z7T(

AWEIW)!E'C.16G$.2(L-1((5;%D-H@_H+HH>@,.B*```[ `
end Received on Sun Jun 18 2006 - 06:59:01 CDT