>>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