>>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.
Cy Welch
Senior Programmer/Analyst
MetSYS Inc