http://www.gurubee.net/article/55512
버젼별로 정리되어있씁니다.
WITH T1 ( RN , NM , GB ) AS ( SELECT 1 , '김가나', '승인' FROM DUAL UNION ALL SELECT 2 , '박승대', '승인' FROM DUAL UNION ALL SELECT 3 , '오천식', '승인' FROM DUAL ) , T2 ( RN , NM , GB ) AS ( SELECT 1 , '박충식', '불승인' FROM DUAL UNION ALL SELECT 2 , '김가나', '불승인' FROM DUAL UNION ALL SELECT 3 , '오천식', '불승인' FROM DUAL ) SELECT NVL(A.NM,B.NM) NM , A.GB || CASE WHEN A.GB IS NOT NULL AND B.GB IS NOT NULL THEN ',' END || B.GB AS GB FROM T1 A FULL OUTER JOIN T2 B ON A.NM = B.NM