联表查询更新

update Table1 set a.key1 = b.key1,a.key2= 'value2'
from Table1 as a, Table2 as b
where a.key3= b.key3 and a.key4 = 'value'