If you use a JOIN and the external loop table have not a index for the ON condition, VFP build a temp index for do the join with o(n1Log(n2)) complexity.
Add a index into the Table2 for cID field, and the select run in a flash:
SELECT Table2 INDEX ON cID TAG cID ....
You're right, it works fine with an index. The strange thing is that now without an index it also executes fast. I don´t know what happened before.
