CUCU2/src/custom/restcontroller/webmanage/saletool/courseware/SQL/员工列表查询.sql

select t1.hrid,
       t1.hrcode,
       t1.name,
       t1.phonenumber,
       t1.position,
       t1.userid,
       t2.depname,
       t2.depfullname
from sys_hr t1
         inner join sys_department t2 on t1.siteid = t2.siteid and t1.departmentid = t2.departmentid
where t1.siteid = $siteid$
  and t1.departmentid in $departmentid$ and $where$