2018-11-15从主节点找子节点
2018-11-15 本文已影响0人
Harry小哥哥
SELECT temp.* FROM
(SELECT
a.GROUP_TAG,a.PAR_ID
FROM
OA_T_SYS_DIC_TAG a START WITH a.ID = '1' CONNECT BY PRIOR a.ID = a.PAR_ID
ORDER BY
a.ID) temp LEFT JOIN OA_T_SYS_DIC_TAG oaTag ON temp.GROUP_TAG = oaTag.GROUP_TAG
WHERE temp.PAR_ID='11'