Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Too Many Subqueries
Message
 
To
12/10/2001 13:04:58
Peter Wagner
Point Informática Ltda.
Limeira, Brazil
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00567770
Message ID:
00567780
Views:
16
>Hi all,
>In a SQL SELECT command using 11 Tables I have 10 LEFT JOINS and
>1 INNER JOIN, but VFP returns a error message: TOO MANY SUBQUERIES.
>
>I'm not using Query Builder, and there arent Subqueries in the Command.
>If I use only 10 Tables it Works fine!
>
>Is there a restriction of how many Tables I can use in a SQL SELECT command
>in VFP, I searched all the documentation and havent found any mention
>that VFP handles only 10 Tables.

Yes, there is the restriction for 10 tables (9 JOINs per query) The same limitation goes for UNION clause.
You can break your query in two or more.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Previous
Reply
Map
View

Click here to load this message in the networking platform