WITH T1 AS
(
SELECT '10007' AS DEPT, '영업팀' AS TEAM, 'C_001_006_001' AS TREEID, 'C_001_006' AS UPTREEID, 2 AS DEPTH FROM DUAL
UNION ALL
SELECT '10050' AS DEPT, '서울공장' AS TEAM, 'C_001_006' AS TREEID, 'C_001' AS UPTREEID, 1 AS DEPTH FROM DUAL
UNION ALL
SELECT '10090' AS DEPT, '본사' AS TEAM, 'C_001' AS TREEID, '*' AS UPTREEID, 0 AS DEPTH FROM DUAL
), T2 AS
(
SELECT '10007' AS DEPT FROM DUAL
)
SELECT
FROM T2 A, T1 B;
T2 테이블을 기준으로 아래와 같이 출력할수 있을까요?
DEPT 팀
10007, 본사 서울공장 영업팀
|