Fabio is saying look at SYS(3054). And check out the "Using Rushmore Query Optimization to Speed Data Access" help topic.

>vfp works in this manner (look 3054 ), and the two queries are executed with the same schema.
>the first syntax it is the correct form
>the second syntax is equal to the first with INNER JOIN, LEFT JOIN, not with RIGHT JOIN and FULL JOIN