处方药品点评的表记录修改

admin

修改人员姓名

1. update HISSYSMANAGER.PRESC_CHECK_RECORD t set t.checker_name=(select j.username from peaas.jill_userdef j where t.checker_code=j.userid)
   
2. where exists (select 0 from peaas.jill_userdef j where t.checker_code=j.userid);--门诊
   
3. 
   
4. update  MRE.MRE_RECORD_ERROR t set t.checker_name=(select j.username from peaas.jill_userdef j where t.checker_code=j.userid)
   
5. where exists (select 0 from peaas.jill_userdef j where t.checker_code=j.userid);--住院

复制代码

admin