I have 3 tables. A column in table1 needs to be updated the sum of a column that exists in both of the other 2 tables.
aFee = sum(t2.aFee + t3.aFeeADJ)
Join table3 t3 on t3.ID = t2.ID
table1.ID = t2.ID
and table1.column1 = 'Stuff'
and table1.column2 in (1,2)
Msg 157, Level 15, State 1, Line 139
An aggregate may not appear in the set list of an UPDATE statement.
Thank you in advance for any assistance!