VFP itself has a limitation of 10 tables, or 9 joins, per SQL Select statement. I suppose this limit would apply to queries made through the ODBC driver also. You can experiment by paring it down to 9 joins to see if that is indeed the case.
>Unfortunately I cannot find the documentation for the driver so, here's the question:
>
>I'm trying to issue a query against VFP data from SQL server with the data set up as a linked server in SQL Server. When I send the SELECT statement to the ODBC driver, I get an error from the driver stating "Too many subqueries". Is there a limit as to how many joins I can have in the query? Does the limit also exist in the OLE DB provider?
>
>Jon
Steve Gibson