Hola, coloqué :
Código PHP:
SELECT MONTHNAME(date_received) as month, YEAR(date_received) as year,
count(inpayment_id) as total_p, sum(amount) as amount_p,
count(inpayment_id) as total_c, sum(amount) as amount_c
FROM inpayment
LEFT JOIN received_by=total_c
LEFT JOIN received_by=amount_c
WHERE received_by='Company' AND received_by='Client'
GROUP BY MONTHNAME(date_received), YEAR(date_received)
ORDER BY date_received ASC
Y No Funciona...................