Re: Joins in the from clause?

There are many different levels to the ANSI SQL92 standard. RDBMS vendors are only compliant with the entry level of the SQL92 standard to be able to put that "ANSI compliant" tag on their product. No RDBMS vendor currently supports *all* of the SQL92 levels in their products.

In this case, Microsoft supports a further level than other RDBMS vendors. But this in and of itself does not mean that Microsoft supports levels that Oracle and other vendors do not. This just means that Microsoft has chosen this level in this particular case.

HTH,
Brian

KnighThing wrote:
>
> Ok, here's something that's bothering me, if "ANSI" style is in the FROM
> clause and "ANSI" inherently implies it's the standard: Then why is MS SQL
> Server the only database I've seen that supports it?
>
> Oracle, doesn't, and my brief experience with Sybase showed it
> didn't either (though I could easily be wrong).
>
> The whole reason I took the time to learn joins in the FROM clause is
> becuase it was the ANSI standard, but what good is a standard that no one
> follows? :-( Now that I"ve learned it (and like it) I won't be able to
> use it when I switch jobs and start using Oracle.
>
> What does Informix use? Am I wrong about Sybase? Any other
> "major" database vendors I didn't support it?
>
> In article <9at5ik$2hi$05$1_at_news.t-online.com>, Joachim Pense wrote:
> >KnighThing wrote:
> >
> >[wants to use]
> >>
> >> select *
> >> from t1
> >> join t2 on t2.id = t1.id
> >>
> >
> >[Oracle accepts only]
> >
> >>
> >> select *
> >> from t1,t2
> >> where t1.id = t2.id
> >>
> >> My question is, can you do joins in the FROM clause in Oracle and if you
> >> can does it make any difference, performance-wise, where you do the join?
> >
> >I read somewhere that they want to introduce ANSI-Style joins in
> >Oracle 9. I also prefer them for stylistic reasons. I hope that this move is
> >not just syntactical cosmetic but also accompanied by outer joins
> >without the many restrictions Oracle imposes on them now. Also natural
> >joins (i.e. joins that impicitly use foreign key constraints as
> >conditions without explicit mention would be nice to have. Let's wait.
> >
> >Joachim
 

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