On 10/17/06, Niall Litchfield <niall.litchfield_at_gmail.com> wrote:
>
> On 10/17/06, Mladen Gogala <mgogala_at_verizon.net> wrote:
> >
> >
> > On 10/17/2006 01:43:14 AM, Niall Litchfield wrote:
> > > My personal preference is for the ANSI standard syntax, I really find
> > that
> > > seperating out the joins from the other conditions helps me understand
> > more
> > > easily what a query is trying to achieve. It also helps debugging IMO.
> >
> > How, exactly are joins different, in your opinion?
>
>
> it seems to me that where emp.deptno = dept.deptno is an entirely
> different fish from where emp.deptno=10, in the former case you are saying
> how employees and departments are related, in the latter you are specifying
> what criteria you are using to choose data.
>
and what I intended to say was that therefore separating them out makes
errors of logic a lot easier to pick up.
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 17 2006 - 08:30:26 CDT
