really? I find the second form much easier to understand.

| Henry A.L. Wollman Rejoice and be glad!
|_____________________________________________________
| Moody Bible Institute, Database Administrator, [Email address protected]
| 820 N. LaSalle Blvd, Chicago, IL 60610 312-329-2291
|_____________________________________________________

-----Original Message-----
From: Mike Brenner
[mailto:oracledba-ezmlmshield-x3221730.[Email address protected]
Sent: Tuesday, August 03, 2004 5:16 PM
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