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