日期:2014-05-17 浏览次数:20861 次
insert into FYMXrhz(DLFYBM,ZLFYBM,MXFYBM,ZDXMBM,jldw,dj,sl,je,fynf,fyyf,fyr)
select DLFYBM,ZLFYBM,MXFYBM,ZDXMBM,jldw,dj,sum(sl),sum(je),
:con1.nf,:con1.yf,:con1.rr from fymxsj where fynf=:con1.nf and fyyf=:con1.yf
and fyr=:con1.rr group by DLFYBM,ZLFYBM,MXFYBM,ZDXMBM,jldw,dj;