I have this select query which subtracts two columns and then I have a SUm on them. It is working as I am expecting but can I refine my result so that the value 0 is not included in the result
SELECT dbo.Branch.code, dbo.Branch.name AS Branch, SUM(dbo.WarehouseProductQuantity.actualQuantity - dbo.WarehouseProductQuantity.reservedQuantity ) AS AvailQty
Open in new window