Mysql使用笔记20221211 2303

记录20221211 2303

根据员工 工号及类型查询对应单据

select 
wa.apply_user_id,
wa.is_deleted,
hebi2.code,
hebi2.name,
wa.create_time,
wa.title,
wa.begin_date,
wa.end_date,
wa.reason_remark
from wf_apply wa  
left join hr_emp_base_info hebi2 on hebi2.id=wa.apply_user_id 
where wa.apply_user_id in (select id from hr_emp_base_info hebi where hebi.code in('S11601137') )
and wa.category_code ='overtime'

1流程申请表（单据）

select *
-- delete wa
from wf_apply wa  where -- wa.is_deleted =1 and 
wa.apply_user_id in (select id from hr_emp_base_info hebi where hebi.code in('S11601137') )
and wa.id in ('8271392345209796311'