根据部门ID查询部门下的所有人员
--查询当前部门以下的人员SELECT ID 人员ID
from sa_staff_info
where ID in
(SELECT USER_ID
FROM SA_STAFF_ROLE
WHERE DEPT_ID IN
(select DEPT_ID
from SA_DEPT_DICT
start with DEPT_ID = 2092
connect by prior DEPT_ID = UPPER_ID))
沙发不让抢。。。{:2_26:} 楼主不地道,沙发自个抢了
页:
[1]