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 -> ANSI-style joins?

ANSI-style joins?

From: A.J. Fried <aj.fried_at_home.com>
Date: Thu, 04 Mar 1999 15:13:35 GMT
Message-ID: <zqxD2.5$BY3.770409@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
aj.fried_at_home.com <-- Fun Email
fried_at_bessemer.com <-- Work Email Received on Thu Mar 04 1999 - 09:13:35 CST

Original text of this message

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