Hi Sylvain!
I would like to give you an advice to take a look at VFP5FAQ.txt file that you have in your VFP directory. I saw there the similar question (and SQL), so you might find the answers. In short, you should rewrote your SQL to have the following syntax:
select one.firstname as first, one.lastname as second,;
two.firstname as third, two.lastname as fourth;
from (((FirstTable;
left outer join SecondTable One;
on one.SecondID = FirstTable.FirstID);
left outer join SecondTable Two;
on Two.SecondID = FirstTable.FirstID);
left outer join ThirdTable;
on ThirdTable.ThirdID = FirstTable.FirstID);
order by 4,3,2,1
You may replace outer join with your inner.
>
>>Look at the SYS(3054) function. It shows you the optimization levels of
>the SQL SELECT.
>
>SYS(3054, 1) return full optimization on all the tables
* Human is a question asked by birth and answered by death. Machine is another kind of question with another kind of answer