SELECT COUNT(USR_ID) FROM KM_USERINFO WHERE USR_STATUS != 3 AND
USR_CLASS != 2 AND
USR_DEPTCODE IN (SELECT DEPT_CODE FROM KM_DEPTINFO WHERE
DEPT_PARENT != '-1'
CONNECT BY PRIOR DEPT_CODE = DEPT_PARENT START WITH DEPT_CODE =
?)
이게 오라클 커리문 입니다. 이걸 제 나름대로 DB2로 수정햇는데 잘
안돼여
SELECT COUNT(USR_ID) FROM KM_USERINFO WHERE USR_STATUS != 3 AND
USR_CLASS != 2 AND
USR_DEPTCODE IN (with dept(dept_code,dept_parent) as
(
select root.dept_code,root.dept_parent
from km_deptinfo root
where dept_code = '00011'
union all
select sub.dept_code,sub.dept_parent
from km_deptinfo sub, dept super
where sub.DEPT_PARENT = super.dept_code
)
select dept_code from dept where dept_parent !='-1')
요렇게 햇는데 .ㅠㅠ
이걸 전체를 뷰로 만들어야 하나여???
이제 남은 방법은 뷰 뿐인데 ...ㅠㅠ
|