-- 生产领料更新工序说明
update t_im_mdc_mqbentry_m  a set foperationdesc = (SELECT fname from (SELECT a.fname, b.fentryid FROM t_mpdm_workprocedure_l a inner join t_im_mdc_mqbentry b on a.fid = b.fworkprocedureid AND flocaleid='zh_CN') x where a.fentryid = x.fentryid) where exists(SELECT fname from (SELECT a.fname, b.fentryid FROM t_mpdm_workprocedure_l a inner join t_im_mdc_mqbentry b on a.fid = b.fworkprocedureid AND flocaleid='zh_CN') x where a.fentryid = x.fentryid);
