- Identify the target table that needs to be updated.
- Identify the source table from which the update is to be done:
update test01.web_clicks a -- Target update tablefrom test02.wed_address b -- Source update tableset acc_last_date= date -- Target column that's need to updatedwhere a.Rego_Start_Dt between '2016-12-25' and '2017-01-28' -- Partition column