UPDATE

UPDATE with data from another table

Modifying existing values

Updating Specified Rows

Updating All Rows

Capturing Updated records