select (a.上年结转-sum(b.yuesl)+sum(c.yuesl)) as 上年yuesl,a.wlbm
--加入其它需要的数据
from cc_rkckmx a,cc_rkckmx b,cc_rkckmx c
where a.wlyear=2002 and a.wlyear=b.wlyear and a.wlyear=c.wlyear
and a.wlbm=b.wlbm and a.wlbm=c.wlbm
--再加入你需要的其它连接条件
group by a.wlbm---修改修改
--加入其它需要的数据
from cc_rkckmx a,cc_rkckmx b,cc_rkckmx c
where a.wlyear=2002 and a.wlyear=b.wlyear and a.wlyear=c.wlyear
and a.wlbm=b.wlbm and a.wlbm=c.wlbm
--再加入你需要的其它连接条件
group by a.wlbm---修改修改
INSERT INTO cc_rkckmx(bz, wlyear, wlmonth, wlday, wlbm, yuesl, yuedj, yueje) SELECT '上年结转','2003','01','01', b.wlbm, b.yuesl, b.yuedj, b.yueje FROM cc_rkckmx as b WHERE (b.wlbm not in (SELECT wlbm FROM cc_rkckmx group by wlbm,wlyear having wlyear='2002' ) and b.id = (select max(id) from cc_rkckmx as c where c.wlyear='2002' and b.wlbm=c.wlbm ))
SELECT '上年结转', year(getdate()),'01','01', wlbm, yuesl, yuedj, yueje
FROM dbo.cc_rkckmx
WHERE (id IN
(SELECT MAX(id) AS id
FROM dbo.cc_rkckmx
WHERE (wlyear = year(getdate())-1) AND
( bz <> '上年结转')
GROUP BY wlbm))