Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speeding up code-scan,update (follow-up from last Thursd
Message
 
 
To
19/08/2008 13:48:37
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01340003
Message ID:
01340030
Views:
12
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform