>VFP only joins two tables at a time, and you never know which two it will pick. Let's look at an example:
>
>Supplier and Product List are joined to create Temp1
>Temp1 is not indexed, so the next join is only partially optimized
>Temp1 and MemberData are joined to create Temp2
>Temp2 is not indexed so the next join is only partially optimized
>Temp2 and MemberList are joined to create MemberGrid
>
>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