I need to write a select statement that omits invoice records that sum to 0.
Here is an example. In my select statement I do not want to select invoices 31, 33 and 41 because their total value is 0 (the reversal of the invoice cancels the invoice essentially). I would only want to select invoice 45 of $1823.43. I'm stuck on how to do this. Any help would be appreciated.