the INNER JOIN syntax is ANSI standard, also you can do FULL OUTER JOIN
which you can't do using normal oracle SQL syntax

-----Original Message-----
From: Mike Brenner
[mailto:oracledba-ezmlmshield-x3221730.[Email address protected]
Sent: 03 August 2004 23:16
To: LazyDBA Discussion
Subject: Re: SQL QUERY - Just curious


On reason is that as the query gets more complex,
the humans who read it will find it easier to decipher it
if you use the INNER JOIN and LEFT OUTER JOIN notation.


Edwin Uy wrote:
> Is there really a reason why would one choose to use
>
> select emp.ename, dept.dname
> from emp
> INNER JOIN dept
> ON emp.deptno = dept.deptno
>
> instead of ...
>
> select emp.ename, dept.dname
> from emp, dept
> where emp.deptno = dept.deptno



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page