You can provide the values for the SET clause from a SELECT statement that selects data from other tables.
For example, in the customers table, some customers do not have a sale representative. The value of the column saleRepEmployeeNumber is NULL as follows: