I'm trying to build a query which will update one table with values from another, matching on primary keys. It's very simple in ACCESS using an INNER JOIN with an UPDATE. I haven't been able to get it to work in VFP. Can it be done?

Thanks!