第一种方法
UPDATE P_Field_Initial SET P_Field_Initial.FRegion=b.FRegion,
P_Field_Initial.FRegion95=b.FRegion95
FROM P_Field_Initial INNER JOIN P_Field_Initial_Region b ON
P_Field_Initial.FName=b.FName
注意两个表以FName相关联
第二种方法
update TblTeacher
set tTSalary=tTSalary+
isnull((select reward from TblTeacherSalary as tts where tts.ttid=TblTeacher.ttid),0)