>The syntax should be:
>
>SELECT * ;
>FROM table1 INNER JOIN table2 ON table1.key=table2.key ;
>INNER JOIN table3 ON table1.key=table3.key
>
>You have the INNER JOIN and ON statements grouped together.
>
I'll try it. The syntax of the inner join was made up by foxpro itself in the query builder (it does not work). The old way in the second example was created by me (and it works)

Peter