>If I want to connect 3 tables in view, it generates wrong resolt, because view automatical make wrong joins:
>

FROM table1 INNER JOIN table2 INNER JOIN table3 <BR>ON table1.field = table2.field ON tabel1.field = table3.field

>Instead of
>

FROM table1 INNER JOIN table2 ON tabel1.field = table2.field <BR>INNER JOIN table3 ON table1.field = table3.field

>
>Why? How to correct it?

Giedrius,

The view designer creates its join syntax in the enst join style, both nested and sequential are supported by VFP.

Nested

FROM Table1 JOIN Table2 ;
            JOIN Table3 ;
          ON Table1.Field = Table3.Field ;
        ON Table1.Field = Table2.Field

Is equivalent to (Sequential);

FROM Table1 JOIN Table2 ON Table1.Field = Table2.Field ;
            JOIN Table3 ON Table1.Field = Table3.Field