SQL Update Multiple Columns

Below Sql use to update multiple column for a table in 1 shot


*****************

UPDATE Table1
SET (Col1, Col2, Col3, Col4) = 
(SELECT Col1a, Col2a, Col3a, Col4a FROM Table2 WHERECol5a=Table1.Col5) 
WHERE Col5 IN (SELECT Col5a FROM Table2 )

*****************