UPDATE with data from another table
The examples below fill in a PhoneNumber for any Employee who is also a Customer and currently does not have a
phone number set in the Employees Table.
(These examples use the Employees and Customers tables from the Example Databases.)
Update using a correlated subquery:
Update using MERGE:
Update using INNER JOIN: