试试这样
insert into cw_ysz(lxr,khdw_bm,khdw,yearmonth,qcye)
(select lxr,khdw_bm,khdw,yearmonth,qcye from cw_ysz where yearmonth='200502')
union all
(SELECT lxr,khdw_bm,khdw,yearmonth,qmye FROM cw_ysz where yearmonth='200501')
insert into cw_ysz(lxr,khdw_bm,khdw,yearmonth,qcye)
(select lxr,khdw_bm,khdw,yearmonth,qcye from cw_ysz where yearmonth='200502')
union all
(SELECT lxr,khdw_bm,khdw,yearmonth,qmye FROM cw_ysz where yearmonth='200501')
Update A Set qcye=(Select qmye from cw_ysz Where khdw_bm=A.khdw_bm and lxr=A.lxr and khdw=A.khdw And yearmonth='200501')
from cw_ysz A Where yearmonth='200502'
应该是插入一条新的记录
insert into insert into cw_ysz(lxr,khdw_bm,khdw,yearmonth,qcye)
(SELECT lxr,khdw_bm,khdw,'200502',qmye FROM cw_ysz where yearmonth='200501')
insert into cw_ysz(lxr,khdw_bm,khdw,yearmonth,qcye)
(SELECT lxr,khdw_bm,khdw,'200502',qmye FROM cw_ysz where yearmonth='200501')