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:
00567776
Views:
9
>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.

From the SELECT - SQL Command help in VFP7:

"There are limits to the number joins you can use. The maximum number of joins per Select statement is nine. "

You can work around this by doing two SELECT statements.
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Previous
Reply
Map
View

Click here to load this message in the networking platform