>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!

Nope.
What can be done, though, is to use a SET RELATION between the tables and a REPLACE ALL. This works very fast.

e.g. This will update the UpdateMe table from values in SourceTable
where the primary keys match.

Use SourceTable Order idPK
Select 0
Use UpdateMe
Set Relation To idPK Into SourceTable
Replace All field1 With SourceTable.field1, ;   
            field3 With SourceTable.field2, ;
            etc., etc. ;
    For !EOF("SourceTable")