select sdDept.id from ( select sd.id dept_id, sd.dept_index from sys_dept_emp sde left join sys_dept sd on (sd.id = sde.dept_id and sd.del_state = 0 and sd.dept_state = 0) where sde.emp_id = #{createEmpId} and sde.company_id = #{companyId}) templef.
mysql
2023-10-11
40 点赞
0 评论
60 浏览
