Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Too many subqueries (error 1805)
Message
From
28/07/1999 12:13:15
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Too many subqueries (error 1805)
Miscellaneous
Thread ID:
00247212
Message ID:
00247212
Views:
50
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
Next
Reply
Map
View

Click here to load this message in the networking platform