select a.rylbdm,a.rylb,sum(a.rs1) rs1,sum(a.rs2) rs2,sum(a.rs3) rs3,sum(a.rs4) rs4,
sum(a.rs5) rs5,sum(a.rs6) rs6,sum(a.rs7) rs7,sum(a.rs8) rs8,sum(a.rs9) rs9,sum(a.rs10) rs10,
sum(a.rs11) rs11,sum(a.rs12) rs12,sum(a.rs13) rs13,sum(a.rs14) rs14,sum(a.rs15) rs15,
sum(a.rs16) rs16,sum(a.rs17) rs17,sum(b.rs18) rs18,sum(b.rs19) rs19,sum(b.rs20) rs20,
sum(b.rs21) rs21,sum(b.rs22) rs22,sum(b.rs23) rs23,sum(b.rs24) rs24,sum(b.rs25) rs25,
sum(b.rs26) rs26,sum(b.rs27) rs27,sum(b.rs28) rs28,sum(b.rs29) rs29,sum(b.rs30) rs30,
sum(b.rs31) rs31,sum(b.rs32) rs32,sum(b.rs33) rs33,sum(b.rs34) rs34
from gwtj1 a,gwtj2 b
where a.rylbdm=b.rylbdm(+) and a.bs='*'
and a.rylbdm is not null and b.rylbdm is not null
group by a.rylbdm,a.rylb
order by a.rylbdm
sum(a.rs5) rs5,sum(a.rs6) rs6,sum(a.rs7) rs7,sum(a.rs8) rs8,sum(a.rs9) rs9,sum(a.rs10) rs10,
sum(a.rs11) rs11,sum(a.rs12) rs12,sum(a.rs13) rs13,sum(a.rs14) rs14,sum(a.rs15) rs15,
sum(a.rs16) rs16,sum(a.rs17) rs17,sum(b.rs18) rs18,sum(b.rs19) rs19,sum(b.rs20) rs20,
sum(b.rs21) rs21,sum(b.rs22) rs22,sum(b.rs23) rs23,sum(b.rs24) rs24,sum(b.rs25) rs25,
sum(b.rs26) rs26,sum(b.rs27) rs27,sum(b.rs28) rs28,sum(b.rs29) rs29,sum(b.rs30) rs30,
sum(b.rs31) rs31,sum(b.rs32) rs32,sum(b.rs33) rs33,sum(b.rs34) rs34
from gwtj1 a,gwtj2 b
where a.rylbdm=b.rylbdm(+) and a.bs='*'
and a.rylbdm is not null and b.rylbdm is not null
group by a.rylbdm,a.rylb
order by a.rylbdm
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货