SELECT
BNUM,
DECODE(DEPTH,0,SUBJECT,CONCAT(LPAD(' ',DEPTH*4,' '),CONCAT('RE : ',SUBJECT))) SUBJECT,
GROUPNUM,
DEPTH,
ORDERNO,
PARENT
FROM BOARD
ORDER BY groupnum desc, orderno
;
bnum subject groupnum depth orderno parent
5 a 1 0 0 0
11 a-4 2 2 1 9
10 a-3 2 2 1 7
7 a-1 2 1 1 5
9 a-2 2 1 2 5
이렇게 나오는데 parent에 맞게 답글이 밑으로가게 하려면 어케하나요?