UPDATE members_gwtz SET gwtz_dqhuanjie = '流程关闭' , gwtz_dqzrren = '存档' WHERE gwtz_id in (SELECT ta.gwtz_id FROM (select * from members_gwtz) ta LEFT JOIN members_gwtz_pro AS tb ON ta.gwtz_id = tb.gwtz_pro_uid WHERE ta.gwtz_dqhuanjie = '' AND tb.gwtz_pro_huanjie = '人力资源信息录入')