Re: Joins in the from clause?

Joachim,

> I used the term "ANSI style" just as a short (and, as you point, not
> quite correct) label denoting the
>
> from a inner join b on a.x = b.x inner join c on a.y = c.y
>
> join syntax, as opposed to the traditional
>
> from a, b, c where a.x = b.x and a.y = c.y
>
> style, because I think (not quite sure) that the first style was
> introduced by the ANSI commitee. I do not care much if Oracle is
> ANSI-compliant in this respect (it probably is), it is just that I
> happen to like the new style.

You may be correct, it may have been the first style introduced. I was just pointing out *why* Oracle claims to be ANSI compliant with the SQL92 standard and Microsoft claims to be ANSI compliant with the SQL92 standard, but one can do it one way in Microsoft, but not in Oracle when ANSI says that both are part of the standard.

And I don't deny that your preference isn't of importance to you! Personally, I like the more traditional example you cited second above. But I only like it that way cuz it's the way that I learned it the first time! Call me "old-fashioned", but I like it that way.

Enjoy SQL!
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================