WITH mst_t AS
(
SELECT 'A' cd1 FROM dual
UNION ALL SELECT 'B' FROM dual
UNION ALL SELECT 'C' FROM dual
)
, data_t AS
(
SELECT 'A' cd1, 'P1' cd2 FROM dual
UNION ALL SELECT 'A', 'P2' FROM dual
UNION ALL SELECT 'B', 'P2' FROM dual
UNION ALL SELECT 'B', 'P3' FROM dual
UNION ALL SELECT 'C', 'P1' FROM dual
UNION ALL SELECT 'C', 'P2' FROM dual
UNION ALL SELECT 'C', 'P4' FROM dual
)
SELECT a.cd1, b.cd2
  FROM mst_t a
  LEFT OUTER JOIN data_t b
 PARTITION BY (b.cd2)
    ON a.cd1 = b.cd1
 WHERE b.cd1 IS NULL
 ORDER BY a.cd1, b.cd2
;

-결과-
CD1 CD2
--- ---
A   P3
A   P4
B   P1
B   P4
C   P3

 마농님 너무 감사합니다~

그런데 한컬럼이 더 필요한데 역시나..잘안되네요.ㅠ

P3를 가진 조인테이블의 CD1 컬럼이 하나만 나오면되는구조에요..

-결과-

SELECT cd1, cd3, cd2
  FROM (SELECT a.cd1
             , MIN(b.cd1) OVER(PARTITION BY b.cd2) cd3
             , b.cd2
             , b.cd1 x
          FROM mst_t a
          LEFT OUTER JOIN data_t b
         PARTITION BY (b.cd2)
            ON a.cd1 = b.cd1
        )
 WHERE x IS NULL
 ORDER BY cd1, cd3
;