update sysmnsys_user sss set PHY_con_code = select sh医保编码 from sysmnehr_service_personal se left join sysmnsys_user su on seperson_id = superson_id left join sysmn昊泽对接_职员 sh on serecord_number = sh身
UPDATE sysmn.sys_user sss
SET PHY_con_code = (
SELECT DISTINCT sh.医保编码
FROM sysmn.ehr_service_personal se
LEFT JOIN sysmn.sys_user su ON se.person_id = su.person_id
LEFT JOIN sysmn.昊泽对接_职员 sh ON se.record_number = sh.身份证号
WHERE se.del_flag = '0' AND su.del_flag = '0' AND su.user_id = sss.user_id
)
原文地址: http://www.cveoy.top/t/topic/iHsd 著作权归作者所有。请勿转载和采集!