By using this simple database project you can update one table by another table.
Download the application. There is a SQL stored procedure named "MultiTableUpdate". Run the stored procedure.
Execute dbo.MultiTableUpdate
You can get the SQL Code inside the "MultiTableUpdate" stored procedure.