Thank you both!


>>>>I have a table called Movement with a date field, mov_stout1, which I want to update from a more recent
>>>>copy of the same table.
>>>>
>>>>How doI code the SQL for this?
>>>
>>>What is reletationship between those tables? What's VFP version?
>>
>>The both have identical structures. One is a copy of the other. The PK mov_pk. Using VFP 9.
>
>Try
>

>UPDATE Movement ;
>		SET mov_stout1 = MovementNew.mov_stout1 ;
>	FROM Movement ;
>		JOIN MovementNew ON MovementNew.mov_pk = Movement.mov_pk
>