I was doing a search for the ability to do a select in a SQL Update statement came across this in one of the threads.

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)

Thanks,
Steve