Hola, para hacer eso necesitas hacer un join.
Código:
SELECT MONTHNAME(date_received) as month, YEAR(date_received) as year,
count(inpayment_id) as total_p, sum(amount) as amount_p,tabla1.campo1,tabla2.campo2
FROM inpayment
LEFT JOIN inpayment.recibed_by = tabla1.campo1
LEFT join inpayment.recibed_by = tabla2.campo2
WHERE received_by='Company'
GROUP BY MONTHNAME(date_received), YEAR(date_received)
ORDER BY date_received ASC
No estoy seguro de haber cogido bien los campos que dices, pero bueno, el esquema que necesitas es este. En lugar de tabla1.campo1, tendras que poner el count() o sum().
Espero que te ayude.