I'm looking for a query to return the sum of all payments against an invoice ID - however, if there are no payments noted, the query below returns null. Is there any way of it returning 0 instead of null? I've tried adding ?? 0 at the end, but get the message I'm looking for a query to return the sum of al