Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> format of join

format of join

From: <enunezf_at_gmail.com>
Date: 9 Jan 2006 17:41:16 -0800
Message-ID: <1136857276.409192.54520@g47g2000cwa.googlegroups.com>


In the first place, excuse by my badly groins. Now my question:
¿Which is the best form to write a consultation of the type join?

Ansi-89:
Select A.attribute1, B.attribute2
>From table1 A, table2 B

Where A.key1 = B.key2

Or Ansi-92

Select A.attribute1, B.attribute2
>From table1 A

Inner Join table2 B On A.key1 = B.key2

Thank
Enrique Received on Mon Jan 09 2006 - 19:41:16 CST

Original text of this message

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