81,092
社区成员
发帖
与我相关
我的任务
分享
insert into forbidden_employee(id,forbidden_employee_name,forbidden_employee_id,forbidden_employee_sex,forbidden_employee_bir,forbidden_employee_hu_ji,forbidden_employee_edu,forbidden_employee_addr,zan_zhu_id,image,image_name,sure_desc,note,insert_worker) select SEQ_forbidden_employee_ID.Nextval,a.personnel_name,a.personnel_cardid,a.sex,a.birthday,(select xzqu_note from xzqu where xzqu_code=a.county_code),(select edu_note from edu where edu_code=a.edu),a.address,a.zan_zhu_code,a.face_image,a.face_image_name,'','从业人员审核为不可从业人员','system' from personnel a where a.personnel_id=81
insert into forbidden_employee(id,forbidden_employee_name,forbidden_employee_id,forbidden_employee_sex,forbidden_employee_bir,forbidden_employee_hu_ji,forbidden_employee_edu,forbidden_employee_addr,zan_zhu_id,image,image_name,sure_desc,note,insert_worker)
select SEQ_forbidden_employee_ID.Nextval,a.personnel_name,a.personnel_cardid,a.sex,a.birthday,(select xzqu_note from xzqu where xzqu_code=a.county_code),(select edu_note from edu where edu_code=a.edu),a.address,a.zan_zhu_code,a.face_image,a.face_image_name,'','从业人员审核为不可从业人员','system' from personnel a where a.personnel_id=81