declare @ta table(a int, b int)insert into @ta values(1, 3)insert into @ta values(2, 4)insert into @ta values(1, 43)
declare @tb table(a int, c int)insert into @tb values(1, 3)insert into @tb values(3, 4)
update @tbset c = a.bfrom @tb b, (select a, sum(b) as b from @ta group by a) awhere b.a = a.a
select * from @tb
转载于:https://www.cnblogs.com/antony1029/archive/2006/07/20/455956.html
