>I do prefer JOIN. But do you think that it is possible that using WHERE produces intermediate results of the size of a Cartesian product, even if the end result is correct?

It's highly unlikely. Even VFP query processor is smart enough to recognize a JOIN even in WHERE form. IOW, the queries will be processed the same way regardless if you use JOIN or WHERE type of join.