------解决方案--------------------
update [表1]
set [考勤工资] = [表2].[考勤工资]
from [表2] where [表1].[考勤类型] = [表2].[考勤类型]
UPDATE Table1,Talbe2
SET Table1.TypeName = Table2.TypeName
WHERE Table1.Name = Table2.Name
------解决方案--------------------
update [表1]
set [考勤工资] = [表2].[考勤工资]
from [表2] where [表1].[考勤类型] = [表2].[考勤类型]
UPDATE Table1,Talbe2
SET Table1.TypeName = Table2.TypeName
WHERE Table1.Name = Table2.Name