Update Multiple Columns Of Multiple Table Using Joins

If you intend to update columns of one table from columns of another table that have common keys, here's how you can do it. Note that this is SQL Server syntax. Other databases like Oracle and MySQL may have different syntax.

UPDATE T1
SET T1.Col1 = T2.COl1, T1.Col2 = T2.Col2
FROM T2 ON T1.Key1 = T2.Key1
WHERE .........