CREATE TABLE #op1 (
	r1 int NULL ,
	r2 int NULL ,
	r3 int NULL ,
	m money NULL 
) 

insert #op1
select  1 ,  2 ,  1 ,  1 
union all
select  1 ,  2 ,  2 ,  1 
union all
select  1 ,  2 ,  3 ,  1 
union all
select  1 ,  2 ,  4 ,  1 
union all
select  1 ,  2 ,  5 ,  1 
union all
select  1 ,  2 ,  6 ,  1 
union all
select  1 ,  2 ,  7 ,  1 
union all
select  1 ,  2 ,  8 ,  1 
union all
select  1 ,  2 ,  9 ,  1 
union all
select  1 ,  2 ,  10 ,  1 
GO


CREATE TABLE #op2 (
	r1 int NULL ,
	r2 int NULL ,
	r3 int NULL ,
	m money NULL 
)
GO

insert #op2
select  1 ,  2 ,  1 ,	 1 
union all
select  1 ,  2 ,  2 ,  2 
union all
select  1 ,  2 ,  2 ,  3 
union all
select  1 ,  3 ,  4 ,  4 
union all
select  1 ,  2 ,  5 ,  5 
union all
select  1 ,  2 ,  5 ,  5 
union all
select  1 ,  3 ,  7 ,  7 
union all
select  1 ,  3 ,  8 ,  8 
union all
select  1 ,  2 ,  1 ,  10 


GO

UPDATE #op1
SET m = #op1.m + Su
FROM #op1, (select #op2.r1, #op2.r2, #op2.r3, sum(#op2.m) As Su
from #op2 
where #op2.r1 =  1  and #op2.r2 =  2  
group by #op2.r1, #op2.r2, #op2.r3) as #op2
WHERE #op2.r1 = #op1.r1 and #op2.r2 = #op1.r2 and #op2.r3 = #op1.r3 

GO

select #op2.r1, #op2.r2, #op2.r3, sum(#op2.m) As Su
from #op2 
where #op2.r1 =  1  and #op2.r2 =  2  
group by #op2.r1, #op2.r2, #op2.r3

select *
from #op1

drop table #op1
drop table #op2