There are two things that need to be done here (and possibly 3). First, you will need to run a query to update totals in table 2 for values that...

It's pretty simple to update a value in one table with data from another.

Here's the example from SQL Books online:

USE pubs

GO

UPDATE titles

SET t.ytd_sales = t.ytd_sales + s.qty

FROM titles t, sales...