Re: Query

[Jorge Ferreira]

Ladies and Gentleman.
Looks like i've solved it. And if some of you it whas elementar, well for me it was a bit of a pain. So for all the others who it might interest here it goes:

SELECT DISTINCT registo.id_reg, (SELECT pagamento.data_pagamento FROM pagamento WHERE id_reg=registo.id_reg ORDER BY data_pagamento DESC limit 0,1) as data_pagamento
FROM registo
LEFT JOIN pagamento on registo.id_reg = pagamento.id_reg

It worked for me. Hope it works for someone else.

Regards,

Jorge