Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> ANSI-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
aj.fried_at_home.com <-- Fun Email
fried_at_bessemer.com <-- Work Email
Received on Thu Mar 04 1999 - 09:13:35 CST
![]() |
![]() |