In Access, my husband updated the values in one table based on the values in another table by putting a JOIN in the SQL. I figured it would be the same in VFP, but I can't figure out how to do it. I don't remember his exact syntax, so I don't know if I'm doing it wrong, or if VFP doesn't support this.

Basically, I'm trying to do:

UPDATE table1
SET table1.field1 = table2.field2
WHERE table1.key = table2.key

So how do I do this?

Thanks,

-Michelle