For the below code why would the result return 1 row and a value of Null for SUM ? In my case StockID 25 does not exist so my assumption is that no rows would be found ? Why is 1 row returned ?
SUM(Interest) As Total
StockID = 25