Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Too many subqueries (error 1805)
Message
De
28/07/1999 12:13:15
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Too many subqueries (error 1805)
Divers
Thread ID:
00247212
Message ID:
00247212
Vues:
57
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
Fil
Voir

Click here to load this message in the networking platform