How to do it...

1. Identify the target table that needs to be updated.
2. Identify the source table from which the update is to be done:

update test01.web_clicks a -- Target update table
from test02.wed_address b -- Source update table
set acc_last_date= date -- Target column that's need to updated
where a.Rego_Start_Dt between '2016-12-25' and '2017-01-28' -- Partition column