Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
ERR 1805 - SQL: Too many subqueries
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement