>>>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?
>>
>>Would ZAP and APPEND FROM the recent copy work for you?
>
>
>??
>
>I only want to update the mov_stout1 column.
Sorry, misread your question.
Well, then it would be
update myTable set mov_stout1 = mc.mov_stout1 ;
from myTable inner join myCopy mc on
myTable.PK = mc.PK
If it's not broken, fix it until it is.
My Blog