SELECT
INFO.*
,B.*
FROM
(
SELECT
A.*
FROM
(
SELECT
NVL(PROGRAMID,0) PROGRAMID
, NVL(BOARDID,0) BOARDID
, NVL(PARENTID,0) PARENTID
, NVL(BOARDSEQNO,0) BOARDSEQNO
, WRITERNAME
, WRITERTEL
, WRITERHTEL
, WRITERADDR
, WRITEREMAIL
, TO_CHAR(WRITEDATE, 'YYYY-MM-DD') AS WRITEDATE
, WRITERBUSEO
, NVL(READCOUNT,0) READCOUNT
, NAME1
, SOSOK1
, JIKCHAK1
, NAME2
, SOSOK2
, JIKCHAK2
, REMOTEIP
, TITLE
, CONTENTS
, ISREPLY
, ISFILE
, ISDELETE
FROM HP_MEETYOU_BUJORI
WHERE PARENTID = 0
) A
) INFO inner JOIN
(
SELECT
NVL(PROGRAMID,0) AS RE_PROGRAMID
, NVL(BOARDID,0) AS RE_BOARDID
, NVL(PARENTID,0) AS RE_PARENTID
, NVL(BOARDSEQNO,0) AS RE_BOARDSEQNO
, WRITERNAME AS RE_WRITERNAME
, WRITERTEL AS RE_WRITERTEL
, WRITEREMAIL AS RE_WRITEREMAIL
, TO_CHAR( WRITEDATE,'YYYY-MM-DD') AS RE_WRITEDATE
, NVL(READCOUNT,0) AS RE_READCOUNT
, REMOTEIP AS RE_REMOTEIP
, TITLE AS RE_TITLE
, CONTENTS AS RE_CONTENTS
, ISREPLY AS RE_ISREPLY
, ISFILE AS RE_ISFILE
, ISDELETE AS RE_ISDELETE
FROM HP_MEETYOU_BUJORI
WHERE PARENTID > 0
) B
ON INFO.BOARDID=B.RE_PROGRAMID
parentid가 boardid의 부모값인데 parentid와 boarid가 같으면 한레코드에 보여지게 해야합니다
첨부파일과 같이 5개의 row가 나오는데 마지막로우에 있는 re_parentid와 첫번로우에 있는 boardid와 값이 403으로 같습니다
그러면 마지막row가 첫번째 로우 뒤에 re_를 붙여서 나오게 해야합니다
고수님들 도와주세요!