테이블이 3개 인가요?

혹시 1개 테이블에서 조건 달리하여 3번 뽑은거 아닌가요?

SELECT wdate
     , MIN(DECODE(gb, 1, srl)) srl1
     , MIN(DECODE(gb, 2, srl)) srl2
     , MIN(DECODE(gb, 3, srl)) srl3
  FROM (SELECT gb
             , wdate, srl
             , ROW_NUMBER() OVER(PARTITION BY wdate, gb ORDER BY srl) rn
          FROM (SELECT 1 gb, wdate, srl FROM t1
                 UNION ALL
                SELECT 2 gb, wdate, srl FROM t2
                 UNION ALL
                SELECT 3 gb, wdate, srl FROM t3
                )
        )
 GROUP BY wdate, rn
 ORDER BY wdate, rn
;

마농님 감사합니다^^

테이블 3개 이상 입니다~~

덕분에 잘 해결했습니다^^