Roy Harvey
3/30/2007 11:02:00 AM
I have never seen that (+) bit before, and when I tested the sample
code it returned a syntax error. Was the example labeled as Microsoft
SQL Server? I suspect it might be some other dialect. It reminds me
of some of the obsolete outer join syntax that used to be in some SQL
implementations.
Roy Harvey
Beacon Falls, CT
On Fri, 30 Mar 2007 02:22:00 -0700, Sudhakara.T.P.
<SudhakaraTP@discussions.microsoft.com> wrote:
>Hi,
>When I was browsing some site, I came across a query as follows:
>select a.*, b.*
>from a inner join b on a.field1 = b.field1
>where (a.field2 (+)=b.field2).
>
>Could any one please interpret this for me or let me know the materials that
>I get to learn these techniques. I am eager to learn these things.
>
>Regards,
>Sudhakara.T.P.