Delete Lines from table if the sum of multiple lines is Nil (based on criteria) – Mysql
I'm working with the following table where you can get activity from customer purchases. DateOfActivity CustomerReference Reference Line Description Receivable Amount 24/10/2022 CUST567 1 Credit Purchase 20,000 24/10/2022 CUST567 4 Credit Purchase 10,000 24/10/2022 CUST555 2 Credit Purchase 50,000 27/10/2022…