I have been trouble writing a SQL query to roll up multiple balances based on a similar ID group and display the balance against the product with a flag of N:
The desired results are below. Would anyone have a fix for this available? As you could see the client '1' maintains all its attributes except the balance field receives the aggregation of the other records.
Would anyone know a query for this?