Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Joins in the from clause?

Re: Joins in the from clause?

From: Kerry Scott <kerrysco_at_ameritech.net>
Date: Wed, 11 Apr 2001 06:38:34 -0400
Message-ID: <psWA6.13679$W81.26612@nntp0.chicago.il.ameritech.net>

Oracle9i does support ANSI-92 SQL. So, your join syntax will work.

Just My 2 Cents

"Robert Spikol" <bspikol_at_home.com> wrote in message news:bduA6.36381$Os.7952263_at_news1.rdc2.pa.home.com...
> 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 Wed Apr 11 2001 - 05:38:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US