>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