>>Update TableA Set Field1 = ST.Sum_TOT
>>FROM TableA INNER JOIN (select sum(FldA+FldB) as Sum_Tot from TableB group by FldC) ST
>>ON TableA.FieldC = ST.FieldC