>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.