I am using SQL Server 2008 and have two tables, table_1 and table_2.
I would like to update the Weight column in table_1 (add to current value) from the weight column in table_2 based on the ID columns in table_1 and table_2.
I would like to do this by Grouping table_2 by ID then updating the Weight column of each corresponding ID in table_1.
Table_1 should look like this when applied:
Is there a way to do this implicitly? In other words, Weights of ALL ID values in table_2 get grouped then applied (added to) Weight columns of the corresponding table_1 ID values?