>Using VFP 8.1. Which may answer this question: is joining to a Select a new feature in VFP 9? At the moment it's throwing an error on that line.

Yes it's. You're missing a lot by not upgrading to VFP9. In VFP8 you've to split the query into 2 separate queries.