Re: Different syntax for LEFT JOIN

From: Richard Kuhler <noone_at_nowhere.com>
Date: Mon, 22 Nov 2004 19:57:24 GMT
Message-ID: <Ewrod.57687$hN1.4218@twister.socal.rr.com>

Michel Cadot wrote:

> "Ruslan Kogan" <ruslan00_at_yahoo.com> a écrit dans le message de

>>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

>
> These two queries are different,

Agreed.

> the first one is an inner join and the last one an outer join.

Not true. The keyword "OUTER" is optional. The keywords FULL, LEFT and RIGHT all indicate an outer join.

<snip>

--
Richard Kuhler

Received on Mon Nov 22 2004 - 13:57:24 CST