Client ran an update query and removed all phone numbers from the phone field of the Customers table.
Client restored database to a new named instance.
Client renamed Customers table in new instance to CustomersRestored.
CustomersRestored table was copied from new instance into production database.
Production database now has a table Customers and a table CustomersRestored.
Desire: Copy all phone data from CustomersRestored into Customers table matching on the Customer Account Number field.
Don't know how to write the query to make this happen. Can anyone help?