用其它的 Table 來更新資料(Update From Table)

UPDATE table1
SET table1.col = table2.col1
FROM table2 WHERE table2.oldCol = table1.col