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?