[SQL QUERY] FIND ROWS THAT ARE NOT MAPPED IN OUTER JOIN TABLES

WITH A AS (

SELECT 1 A, '매핑' MAPPED FROM DUAL UNION ALL

SELECT 2 A, '매핑' MAPPED FROM DUAL UNION ALL

SELECT 3 A, '미매핑' MAPPED FROM DUAL UNION ALL

SELECT 4 A, '매핑' MAPPED FROM DUAL),B

AS (

SELECT 1 A, '매핑' MAPPED FROM DUAL UNION ALL

SELECT 2 A, '매핑' MAPPED FROM DUAL UNION ALL

SELECT 4 A, '매핑' MAPPED FROM DUAL union all

SELECT 5 A, '미매핑' MAPPED FROM DUAL

)

SELECT * FROM A,B

WHERE 1=1

AND A.A(+) = B.A

AND A.A IS NULL

OUTER JOIN 에서 NOMAPPING 되는 ROW 찾기 

ㅋㅋ 테스트 확인