select a.cust_code,sum(c.MON_IN_CHARGE_00) 当月,sum(c.MON_IN_CHARGE_01) 上一个月,sum(c.MON_IN_CHARGE_02) 上二个月,sum(c.MON_IN_CHARGE_03) 上三个月,sum(c.MON_IN_CHARGE_04) 上四个月,sum(c.MON_IN_CHARGE_05) 上五个月
from DW_CC_CUST_INFO_VIP_201306 a
left join DS_CHN_PRD_SERV_20130715 b on a.cust_id=b.cust_id
left join DS_CHN_ACT_SERV_CONSUME_INFO c on b.serv_id=c.serv_id
where a.vip_pz_flag=1
group by a.cust_code
order by a.cust_code