you can try with:

SELECT Table1.*, LOOKUP(Table2.SomeField,Table1.cId,Table2.cID) SomeField;
FROM Table1
INTO...


Thank you, this also works but is very slow.


Zakaria al Azhar


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
....