WITH t AS
(
SELECT 'A' AA FROM dual
UNION ALL SELECT 'B' AA FROM dual
UNION ALL SELECT 'C' AA FROM dual
)
,
K AS
(
SELECT 'R' 구분, 'A' AA, '5' BB FROM dual
UNION ALL SELECT 'R' 구분, 'B' AA, '6' BB FROM dual
)
SELECT K.구분, T.AA, NVL(K.BB, 0) BB
FROM T
, K
WHERE T.AA = K.AA(+)
;
[구분]열에 널이 아닌 R 인 값을 찍고싶은데 --;; ㅠㅠ 어떻게 하면 좋을까요 도와주세요 ㅠㅠ
|