실력이 무지라서..

select to_char(sdate,'yyyymm') sdate, sum(nvl(amt1,0)), sum(nvl(amt2,0)) from (
select to_date(sdate,'yyyymmdd') sdate, amt amt1, null amt2 from (
select '20090301' sdate, 5000 amt from dual
union all
select '20090501' sdate, 1000 amt from dual
union all
select '20090502' sdate, 1000 amt from dual
union all
select '20090601' sdate, 2000 amt from dual
union all
select '20090602' sdate, 2000 amt from dual)
union all
select to_date(sdate,'yyyymmdd') sdate, null amt1, amt amt2 from (
select '20090401' sdate, 1000 amt from dual
union all
select '20090501' sdate, 500 amt from dual
union all
select '20090502' sdate, 500 amt from dual
union all
select '20090601' sdate, 1000 amt from dual
union all
select '20090602' sdate, 1000 amt from dual))
group by to_char(sdate,'yyyymm')

이렇게 해봤네요... ORACLE에서 만들어봤습니다. MSSQL에 맞게 바꿔보시길;

아웃터 조인하려햇으나 양쪽다 성립시키기 애매해서 union all로 묶었습니다..


쿼리중간 daul테이블은 데이터 테이블이 없어서 임시 데이터 만들기위해 쓴거니...