UPDATE table1 set mycolumn = table2.mymatchedcolumn ; WHERE (table1.keyid == table2.keyid )Where keyid is a foreign key into table2 from table1. I am using INDEXSEEK(), with lMovePointer turned on, to do similar things now, but it makes me slightly uncomfortable. :)
UPDATE table1 set mycolumn = table2.mymatchedcolumn; WHERE INDEXSEEK(table1.keyid,.T.,"table2")