Re: Different syntax for LEFT JOIN

Ruslan Kogan wrote:

> hi,
>
> I am just wondering if there is a difference in the following two syntaxes:
>
> SELECT *
> FROM TableA
> LEFT JOIN TableB ON
> TableA.id = TableB.id
>
> SELECT *
> FROM TableA, TableB
> WHERE
> TableA.id(+) = TableB.id
>
> is this correct? I am a little confused about where to position the '(+)'.
>
> Thanks heaps!!!

For a comparison of ISO and ANSI syntaxes: Go to http://www.psoug.org
click on Morgan's Library
click on Joins

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)