SELECT dossier, code_client
FROM reglement_clients
	JOIN (
		SELECT Max(id) m_id
		FROM reglement_clients
		GROUP BY dossier, code_client
	) td_c_g
		ON reglement_clients.id=td_c_g.m_id
WHERE apayer <> 0
ORDER BY dossier ASC;