UPDATE的更新的值是要由另外一个表查询得出:
update mdms_profit as a,mdms_main_ztfi_prctrtype as b set a.ZWDLXMC=b.ZWDLXMC where a.ZWDLXMC is null and a.ZZWDLXBM=b.ZWDLXBM;
UPDATE的更新的值是要由另外一个表查询得出:
update mdms_profit as a,mdms_main_ztfi_prctrtype as b set a.ZWDLXMC=b.ZWDLXMC where a.ZWDLXMC is null and a.ZZWDLXBM=b.ZWDLXBM;