It will still work the same way. VFP joins two tables at a time, creating a temp table for the result. If a third table is needed, it is joined with the temp.

>The query itself does not use JOIN, it uses IN (subquery), although looks like it gets converted into a JOIN internally.