Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Joins in the from clause?
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
![]() |
![]() |