sqlserver批量更新数据

update t_hr_teadept set rjkm=b.yjkm
from t_hr_teadept a
inner join t_tr_bzxx_km b on a.bzh=b.bzh
where a.bmjb='2' and isnull(a.rjkm,'')=''