WITH KEY AS
(
SELECT 1 KEY FROM dual UNION ALL
SELECT 2 KEY FROM dual UNION ALL
SELECT 3 KEY FROM dual UNION ALL
SELECT 4 KEY FROM dual
), TableA AS
(
SELECT 1 KEY, '12/05/01' dt FROM dual UNION ALL
SELECT 2 KEY, '12/05/02' dt FROM dual
), TableB AS
(
SELECT 3 KEY, '11/05/01' dt FROM dual UNION ALL
SELECT 4 KEY, '11/05/02' dt FROM dual
), TAbleC AS
(
SELECT 1 KEY, 1000 amt FROM dual UNION ALL
SELECT 3 KEY, 3000 amt FROM dual         
), TAbleD AS
(
SELECT 2 KEY, 2000 amt FROM dual UNION ALL
SELECT 4 KEY, 4000 amt FROM dual         
)
SELECT  X.KEY,
        NVL(A.DT , B.DT),
        NVL(C.AMT, D.AMT)
FROM    KEY     X
       ,TableA  A
       ,TableB  B  
       ,TableC  C
       ,TableD  D
WHERE   X.KEY = A.KEY(+)
AND     X.KEY = B.KEY(+)
AND     X.KEY = C.KEY(+)
AND     X.KEY = D.KEY(+)
ORDER BY 1

이렇게 쉽게... 해결이.....흑...

이러먼 너무 느려지지는 않나요??