ANSI-style joins?

From: A.J. Fried <aj.fried_at_home.com>
Date: Thu, 04 Mar 1999 15:13:52 GMT
Message-ID: <QqxD2.6$BY3.770409_at_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 - 16:13:52 CET