Re: format of join

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 10 Jan 2006 07:14:09 +0100
Message-ID: <43c350b2$0$17065$626a14ce@news.free.fr>

<enunezf_at_gmail.com> a écrit dans le message de news: 1136857276.409192.54520_at_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

The best one is the one you best understand. For me, the latter one is hard to read but this is just my opinion.

Regards
Michel Cadot Received on Tue Jan 10 2006 - 00:14:09 CST