>>>Has anyone gotten anything like this to work in VFP?
>>>If so, could you share some examples? Or any examples of Update/Select working together.
>>>
>>>UDPATE t1
>>> SET rate = rate + (SELECT increase FROM t2 WHERE id = t1.id)
>>>
Maybe this would work if using ODBC connection:

sqlexec(handle,"select increase from t2 where id = t1.id","tmp")
sqlexec(handle,"update t1 set rate = rate + tmp.increase")