Snip...
>A join containing more than one table is structured like this :

select .. ;
>  from myTable1 ;
>       inner|left|right|outer join myTable2 ;
>       inner|left|right|outer join myTable3 ;
>  on myTable2.id2 = myTable3.id3 ;
>  on myTable1.id1 = myTable2.id2 ;
>       where ...

"on" parts are written in reverse order. And if I don't remember wrong there should be one example in home()+"samples\data\testdata" joining four tables.
>Cetin
Ooops !

select .. ;
>  from myTable1 ;
>       inner|left|right|full join myTable2 ;
>       inner|left|right|full join myTable3 ;
>  on myTable2.id2 = myTable3.id3 ;
>  on myTable1.id1 = myTable2.id2 ;
>       where ...

Cetin