Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Too many subqueries (error 1805)
Hi everybody !!!
I'm trying to make a view (firts for the view desing and late manualy) with 10 tables with not where clause and this message appear when I put the number 10 table. Can somebody help me to understand this behavior?
code example:
CREAT SQL VIEW LV_NAMEVIEW AS ;
SELECT TABLE1.*,;
TABLE2.CNOMBRE AS HEADER1,;
TABLE3.CNOMBRE AS HEADER2,;
TABLE4.CNOMBRE AS HEADER3,;
TABLE5.CNOMBRE AS HEADER4,;
TABLE6.CNOMBRE AS HEADER5,;
TABLE7.CNOMBRE AS HEADER6,;
TABLE8.CNOMBRE AS HEADER7,;
TABLE9.CNOMBRE AS HEADER8,;
TABLE10.CNOMBRE AS HEADE91;
FROM DBC!TABLE1 INNER JOIN DBC!TABLE2;
ON TABLE2.FIELDPK = TABLE1.FIELDFK;
INNER JOIN DBC!TABLE3;
ON TABLE3.FIELDPK = TABLE1.FIELDFK;
INNER JOIN DBC!TABLE4;
ON TABLE4.FIELDPK = TABLE1.FIELDFK;
INNER JOIN DBC!TABLE5;
ON TABLE5.FIELDPK = TABLE1.FIELDFK;
LEFT OUTER JOIN DBC!TABLE6;
ON TABLE6.FIELDPK = TABLE1.FIELDFK;
LEFT OUTER JOIN DBC!TABLE7;
ON TABLE7.FIELDPK = TABLE1.FIELDFK;
LEFT OUTER JOIN DBC!TABLE8;
ON TABLE8.FIELDPK = TABLE1.FIELDFK;
LEFT OUTER JOIN DBC!TABLE9;
ON TABLE9.FIELDPK = TABLE1.FIELDFK;
LEFT OUTER JOIN DBC!TABLE10;
ON TABLE10.FIELDPK = TABLE1.FIELDFK
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