Re: Different syntax for LEFT JOIN

"Ruslan Kogan" <ruslan00_at_yahoo.com> a écrit dans le message de
news:d562b81c.0411212211.1893a476_at_posting.google.com...
> 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!!!

These two queries are different, the first one is an inner join and the last one an outer join.
The Oracle equivalent for the first one is:
select * from tableA, tableB where tableA.id = tableB.id;

The ISO equivalent for the second one is:
select * from tableA right outer join tableB on (tableA.id=tableB.id);