On 10/17/06, Niall Litchfield <niall.litchfield@xxxxxxxxx> wrote:
On 10/17/06, Mladen Gogala <mgogala@xxxxxxxxxxx> 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