In my table, I have a field for Expenses. Upon insert, I want to update the other table with the total sum of all expenses per user.
I have set up a triggered action. However, I can't get it to work because I'm having this error when I use the Sum Function: An aggregate may not appear in the set list of an UPDATE statement. (error code: SQL157)
Can you please help?
Thanks.