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

Home -> Community -> Usenet -> c.d.o.misc -> Oracle 8i / ANSO style joins?

Oracle 8i / ANSO style joins?

From: A.J. Fried <aj.fried_at_home.com>
Date: Wed, 03 Mar 1999 21:28:59 GMT
Message-ID: <vQhD2.2$BY3.276395@IConNet>


I would like to know if Oracle 8i (or, really any known version or Oracle) supports the ANSI-style join syntax, i.e., :

Select	t1.*,
	t2.*
From 	t1
	INNER JOIN
	t2
	ON t1.field1 = t2.field1

As opposed to the "old-style"

Select	t1.*,
	t2.*
From 	t1,t2
Where	t1.field1=t2.field1

Thanks. --> A.J. Fried

--
A.J. Fried
ajfried_at_ix.netcom.com <-- Fun Email
fried_at_bessemer.com <-- Work Email
... Play League Pinball! ... Received on Wed Mar 03 1999 - 15:28:59 CST

Original text of this message

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