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

Re: ANSI-style joins?

From: Eric Otterstein <eotters_at_inetnebr.com>
Date: Thu, 4 Mar 1999 14:35:32 -0600
Message-ID: <7bmqlt$odn$1@owl.inetnebr.com>


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

Original text of this message

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