27,579
社区成员
发帖
与我相关
我的任务
分享
这种只有先添加再删除
1楼的语句是根据你举例的表的结果
要是不管别的字段,那你就改一下语句为:
insert FPMX(FPBH,HTBH,WXBH,WXSH,CPSL) select A.FPBH,A.HTBH,B.WXBH,B.WXSH,B.CPSL from FPMX A inner join (select FPBH, WXBH, WXSH,sum(CPSL) CPSL from XDMX
group by FPBH, WXBH, WXSH) B on a.FPBH=b.FPBH
DELETE a from fpmx a where exists(select 1 from xdmx where fpbh=a.fpbh) and wxbh is NULL
update FPMX set CPSL=B.CPSL,WXBH=B.WXBH, WXSH=B.WXSH
from (select FPBH, WXBH, WXSH,sum(CPSL) CPSL from XDMX
group by FPBH, WXBH, WXSH) B
where FPMX.FPBH=B.FPBH AND FPMX.WXBH=B.WXBH AND FPMX.WXSH=B.WXSH
自己加两个字段就好了??
insert FPMX select A.FPBH,A.HTBH,B.WXBH,B.WXSH,B.CPSL from FPMX A inner join (select FPBH, WXBH, WXSH,sum(CPSL) CPSL from XDMX
group by FPBH, WXBH, WXSH) B on a.FPBH=b.FPBH
DELETE a from fpmx a where exists(select 1 from xdmx where fpbh=a.fpbh) and wxbh is NULL