outer join 은 중복제거 하려고 쓰지는 않는데요.

원하시는 결과 리스트를 올려주세요. ( 중복시 어느값을 가져올지 , 없으면 어떤표시할지 )

질문 내용 수정 하여 다시 올렸습니다. 감사합니다.

with a as
(
select '1' id, '가' name from dual union all
select '2', '나' from dual union all
select '3', '다' from dual union all
select '4', '라' from dual union all
select '5', '마' from dual
)
, b as
(
select '1' id, 90 score from dual union all
select '1', 100 from dual union all
select '2', 30 from dual union all
select '3', 70 from dual union all
select '3', 60 from dual union all
select '5', 60 from dual
)
, c as
(
select '1' id, 'AAA' grade from dual union all
select '1', 'BBB' from dual union all
select '4', 'CCC' from dual union all
select '5', 'BBB' from dual union all
select '5', 'CCC' from dual
)
SELECT X.ID, Y.SCORE, Y.GRADE
  FROM A X
LEFT OUTER JOIN
  (
  SELECT NVL(B.ID, C.ID) ID, B.SCORE, C.GRADE 
    FROM
      (SELECT ROW_NUMBER() OVER(PARTITION BY ID ORDER BY ROWNUM) RNUM, ID, SCORE FROM B) B
    FULL OUTER JOIN
      (SELECT ROW_NUMBER() OVER(PARTITION BY ID ORDER BY ROWNUM) RNUM, ID, GRADE FROM C) C
    ON (B.ID = C.ID AND B.RNUM = C.RNUM)
  ) Y
ON (X.ID = Y.ID)
ORDER BY 1,2,3

같은 ID가 중복일 때 차례대로 조인했는데 실제 테이블에서는 다른 기준을 가지고 조인을 해야할 것 같네요.