I think there are some (ClientID = 1126) in table Receipts.
Change your SQL to:


SELECT Clients.ClientID, Clients.WholeName,
SUM(CASE WHEN Payments.Creditorid = 0 THEN Payments.Amount ELSE...