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

JDP

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

Reference: http://felixhuang.pixnet.net/blog/post/24295759