select bmgz_002,bmgz_003,sum(bmjj_011)+bmgz_007 as gz_009 ,sum(bmjj_011)+bmgz_007+bmgz_010+bmgz_011 as gz_012,sum(bmjj_011)+bmgz_007+bmgz_010+bmgz_011-bmgz_013-bmgz_014-bmgz_015-bmgz_016-bmgz_017 as gz_018 from bmgz,bmjj where bmgz_002 =bmjj_002 and bmgz_003 = bmjj_008 and bmgz_003 = '2013@05' and bmgz_002 in (select bmjj_002 from bmjj where bmjj_003 = '80027' and bmjj_004 = '车后领双针' and bmjj_008 ='2013@05') group by bmgz_002,bmgz_003,bmgz_007,bmgz_010,bmgz_011,bmgz_013,bmgz_014,bmgz_015,bmgz_016,bmgz_017
--要更新的是
update bmgz set bmgz_009 = gz_009(上面查出来的), bmgz_010 = gz_009 where where bmjj_003 = '80027' and bmjj_004 = '车后领双针' and bmjj_008 ='2013@05')
--sql 2005/2008/2012
;with cte as
(
select ... --你的查询语句
)
update t
set t.[] = e.[],...
from bmgz t,cte e
where t.[] = e.[] --两表关联条件，就是你查询到的和这个表的关联条件
and t.[] = ... --其他条件
with t
as
( -- 这个是你上面的查询，没改动
select bmgz_002,bmgz_003,sum(bmjj_011)+bmgz_007 as gz_009 ,
sum(bmjj_011)+bmgz_007+bmgz_010+bmgz_011 as gz_012,
sum(bmjj_011)+bmgz_007+bmgz_010+bmgz_011-bmgz_013-bmgz_014-bmgz_015-bmgz_016-bmgz_017 as gz_018 from bmgz,bmjj where bmgz_002 =bmjj_002 and bmgz_003 = bmjj_008 and bmgz_003 = '2013@05' and bmgz_002 in (select bmjj_002 from bmjj where bmjj_003 = '80027' and bmjj_004 = '车后领双针' and bmjj_008 ='2013@05')
group by bmgz_002,bmgz_003,bmgz_007,bmgz_010,bmgz_011,bmgz_013,bmgz_014,bmgz_015,bmgz_016,bmgz_017
)
--要更新的是
update bmgz
set bmgz_009 = t.gz_009,
bmgz_010 = t.gz_009
from bmgz b
inner join t
on t.bmgz_002 = b.bmgz_002 --关联条件，按照你的需要加
and t.bmgz_003 = b.bmgz_003
where b.bmjj_003 = '80027'
and b.bmjj_004 = '车后领双针'
and b.bmjj_008 ='2013@05'
