update bm_eams_clsz a set a.bm1 = (select b.bm from bm_eams_smcl b where b.mc = a.mc and b.jgbm='01') where exists (select 1 from bm_eams_smcl c where c.mc = a.mc and c.jgbm='01');\
其中 exists 表示条件,相当于是要修改哪些数据,当a.mc = b.mc 存在这些数据的时候,才执行上面的set
update bm_eams_clsz a set a.bm1 = (select b.bm from bm_eams_smcl b where b.mc = a.mc and b.jgbm='01') where exists (select 1 from bm_eams_smcl c where c.mc = a.mc and c.jgbm='01');\
其中 exists 表示条件,相当于是要修改哪些数据,当a.mc = b.mc 存在这些数据的时候,才执行上面的set