There is a reason why they are two seperate tables.
We'd run out of joins, foxpro only allows up to something like 10 joins in an SQL expression.