Different syntax for LEFT JOIN

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!!! Received on Mon Nov 22 2004 - 00:11:51 CST