> You can override VFP's guess by using the FORCE clause. I have never used it >so I don't know how to specify the order of the comparisons.

If you specify FORCE VFP will JOIN the tables on the order you write them
otherwise as you've said VFP will try to optimize the join order