> How would I go about selecting multiple fields from different tables where the conditional expression tests fields from different tables?

Check out VFP help under "select - sql" and look at example #2. There are 13 examples in total.