使用另一个表中的SUM更新表

I am trying to what I thought was going to be a simple update of a table with the sum from another table, but for some reason, it is only updating one row. Here is what the relevant info from the tables look like:I am trying to what I thought was going to be a