SameleveltransferMinidaoDao_getDepartPostUserCount.sql 293 B

123456789101112
  1. select count(*) from
  2. t_bus_user_personnel p
  3. ,t_s_user_org org
  4. ,t_s_base_user bu
  5. where p.userid=org.user_id
  6. and bu.id=p.userid
  7. and bu.id = org.user_id
  8. and org.org_id=:departId
  9. and p.in_postid=:postId
  10. and org.ifpluralism='0' and org.status ='0'
  11. and p.leave_date is null
  12. and bu.delete_flag <> '1'