General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
You'll probably want to do this in steps. Start with the query that is most selective, to help performance.
Ric Unruh
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only