T-SQL update one table from another

When you want to update one table values from another table using following code might help:

UPDATE t1

  SET t1.col2 = t2.col5

  FROM Table1 AS t1

  INNER JOIN Table2 AS t2

  ON t1.Indentifier = t2.Ref_2_t1_Identifier

  WHERE

Read more on Microsoft explanation of UPDATE or stackoverflow.com forum

astu...