>A colleague of mine just stumbled over a limitation regarding the number of joins within a SQL-Statement. He's got a rather complex select statement with more than ten left outer joins (?!?). When performing that select statement, he gets the error "Too many subqueries".
>
>I just wonder whether I have to accept that limitation or am I missing something ?
>
>Bruno
Bruno,
Is there a reason that the query has to be so complex? Running that in VFP may actually cause the SELECT to be slower than breaking it up into multiple statements. VFP will only join 2 tables at a time, and each intermediate join will not be Rushmore optimized. For more information, see the Rushmore KB article on my web site.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer