Re: Joins in the from clause?

I thought that the way Oracle does it is ANSI. Informix does it the same way as Oracle.

"KnighThing" <KnighThing_at_netins.net> wrote in message news:slrn9d4gef.4h3.KnighThing_at_worf.netins.net...
> 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
Received on Mon Apr 09 2001 - 21:28:23 CDT