I have a SQL Select that involves many tables. Using the "new" FROM syntax, I've joined 11 tables using the "INNER JOIN table ON expr" clause. Something like this:

SELECT field1,...,fieldx;
FROM table1;
INNER JOIN table2 ON expr2;
...
INNER JOIN table10 ON expr10

I get ERROR 1805 "SQL: Too many subqueries." When joining just 10 tables instead of 11, the query works fine. If I revert back to the "old" syntax with my join conditions in the WHERE clause, the query seems to work fine, no matter how many tables I join. But I plan on making at least one of these joins an OUTER join so I need the "new" syntax. HELP says that only 2 subqueries per SELECT are allowed - but I don't have any subqueries. Is there a way that I can restructure my FROM clause to make this work?

Thanks
Alan Buch