Re: Joins in the from clause?

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 - 18:12:15 CDT