I am on Mladen's side (at least as far as this topic is concerned)
and I prefer the "old", or rather "traditional" (sounds better,
doesn't it) style. I don't share Niall's opinion that a join
predicate is different from an "ordinary" predicate.
I must confess my complete ignorance re ANSI syntax but regarding your preference for the ANSI syntax because it separates the two types of predicates. How would you express the following with ANSI style join syntax:
select ... from A, B where A.x < B.y
select ... from A, B where A.x between B.y and B.z
or any of the other non-equi joins.
On 10/17/06, Mladen Gogala <<mailto:mgogala@xxxxxxxxxxx>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.