Alan,
You can mix OUTER JOIN and WHERE clauses. Why not use the WHERE construction for your inner joins and keep the "new" syntax for outer joins only?
HTH
Barbara
>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