-- 계층구조인거 같은데요? -- 우선, 아래 쿼리 참조해보세요~ -- 아우터 조인 SELECT A.* , B.* FROM HP_MEETYOU_BUJORI A LEFT OUTER JOIN HP_MEETYOU_BUJORI B ON (INFO.BOARDID=B.RE_PARENTID AND B.PARENTID > 0) ORDER BY A.BOARDID DESC; -- 계층쿼리 SELECT IV0.* , REGEXP_SUBSTR(scbp, '[^/]+', 1, lv) "TITLE & RE_TITLE" FROM (SELECT HMB.*, LEVEL lv, SYS_CONNECT_BY_PATH(TITLE, '/') scbp FROM HP_MEETYOU_BUJORI HMB START WITH PARENTID = 0 CONNECT BY PRIOR BOARDID = RE_PARENTID) IV0;