Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ANSI-style joins?
Sorry, no "Inner Joins" allowed.
A.J. Fried wrote in message ...
>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 - 14:35:32 CST