A 데이블                                                  

tn_no       ku_no       su1                      

    1               1           15

    1               1           20

   1               2            5

B 데이블   

  tn_no         ku_no      su2

    1                  1             30

     1                 2              3

내가 원하는 결과값

     tn_no         ku_no           su1              su2

       1                    1                35               30

       1                    2                 5                   3

select   a.tn_no,a.ku_no,sum(a.su1) ,sum(b.su2)   from   table1   a

left   join  table2 b  on (a.tn_no=b.tn_no  and a.ku_no=b.ku_no)

group by a.tn_no,a,ku_no

이렇게 하니까

tn_no       ku_no            su1           su2

  1                    1                35                60             <---   (  30+30)     중복됨

  1                    2                 5                   3

문제해결방법이  있는것 같은데  부탁드립니다

지금은    두번처리하구 있읍니다    속도가 너무 느려서요   부탁드립니다..