>>>Has anybody seen this error?
>>> Error (1805): SQL: Too many subqueries
>>>It seems to have something to do with the number of left outer joins inside my query. I have 11 left outer join clauses inside my query.
>>
>>The maximum number of joins per Select statement is nine (VFP help).
>
>Which (just for clarity here) means you can have a maximum of 10 tables in a single query.
Actually, it's incorrect. You can have more than 10 tables per query if you join them using WHERE clause instead of JOIN.
--sb--