Hi sharon,

>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.

Maybe then it would be wise to execute two SQL statements after eachother to overcome this limitation.

Walter,