UPDATE (要更新的表) table1 t1 
SET 字段1 = t2.字段1, 字段2 = t2.字段2, 
FROM (数据来源表) table2 t2 
WHERE t1.key = t2.key