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.