>Yes, but you should know that VFP will only join two tables at a time, so at best you'll only get partial optimization.
>

Huh, what's the connection there? Each join will be optimized, using either existing indexes or temp indexes created on the fly. If no outer joins are involved, the engine will determine the best order to join the tables for optimization. (That happens with outer joins, too, to some extent, but outer joins limit the changes in order that can be made.)

Tamar