I have a situation where we have shipping names in our orders table and I would like to place a customer's last name into the field where a null resides.

The orders table is joined to the customers table by a customer id and the field in the customers table that I would like to use in the shipping name in the orders table is the last name.

Please help!