Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Oracle 8i / ANSO style joins?
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