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


Oracle LazyDBA home page