Information générale
Catégorie:
Codage, syntaxe et commandes
>From what I know... The where clause happen after all the records has been >filtered once with the JOIN. I'de use the AND because I'm pretty sure it is >faster. Also, I had a problem once which make me want to use the AND from now >on -)
VFP is "smart enough" to do the WHERE clause stuff first, especially if it's optimizable (and it doesn't seem to matter whether it's a WHERE on records on the left or right side of a JOIN). At least this is what SYS(3054,11) indicates.
It's the HAVING clause that operates after a JOIN (or after anything else for that matter... except ORDER BY of course).
--Brad
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement