>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