>That worked! Thanks. So far I have JOINED 8 of those derived tables. How many can I do?

Yossi,

There's no limit on number of JOINs in a query in VFP9 but the size of SELECT statement (as any other statement in VFP) is limited to 8,192 characters.