My code in MYSQL
is:
SELECT COALESCE(payments.base,0) as total, count(*)
FROM 'payments'
INNER JOIN 'pagos' ON 'pagos'.id = 'payments'.pago_id
INNER JOIN 'documents' ON 'documents'.id = 'pagos'.document_id
INNER JOIN 'clients' ON 'clients'.id = 'documentos'.client_id
WHERE (pagos.money=1 AND (clients.group_id = 14) AND (payments.deleted = 0)
GROUP BY payments.base
ORDER BY payments.base
The result I have is:
total | count(*)
54.8 | 3
399.76 | 2
What I am needing is that the group of 54.8 + 399.76
be added to total = 454.56
.
What do I correct to obtain the expected result?