Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Speeding up code-scan,update (follow-up from last Thursd
Message
 
 
À
19/08/2008 13:48:37
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Divers
Thread ID:
01340003
Message ID:
01340030
Vues:
13
>>2. use INNER JOIN instead of old WHERE. That makes code more readable:
>
>I know this is an old arguement but...............
>
>readability is in the eye of the reader. I used WHERE for multi-table joins for several years before somebody (I think it was Tamar) showed me situations where JOIN is more accurate. I now use JOIN but find WHERE more readable. I liken it to learning a foreign language. No matter how fluent one gets in a second language, it is always more comprehensible in your native tongue.
>
>There are many valid reasons to use JOINS, but for me (and, I assume, Beth) readability is generally not one of them.

I would be curious to see samples when INNER JOIN is not equavalent to WHERE clause. AFAIK we encountered this situation a while ago, I may try to search for a relevant thread. The difference in execution is to when the expression is evaluated. WHERE is evaluated at the end while JOIN is evaluated sooner.

That's the thread I was thinking of, BTW
Re: LEFT JOIN and complex criteria Thread #1156530 Message #1157081
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform