Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error (1805): SQL: Too many subqueries
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00705972
Message ID:
00706165
Views:
19
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform