Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> format of join
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