SQL Query to update multiple column from another table

Description:
In this example we explain that how to update multiple columns from another table in SQL Server or SQL Query to update multiple column form one table to another table in SQL Server.SQL Query to update from one table to another Table based on ID match or join.

Here we demonstrate that how to update table from another table and different database or how to update multiple column from another table with different database. or update field with data from another database.

Query:

Update t1 

set t1.a  = t2.a

   ,t1.b  = t2.b

   ,t1.c  = t2.c

   ,t1.d  = t2.d

   .......

from table1 t1

JOIN table2 t2  ON t1.id = t2.id

WHERE .......