SQLServer把表字段的值更新为其他表对应的值

第一种方法

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)