SELECT * FROM mf_generale
RIGHT JOIN (SELECT * FROM mf_acte
WHERE mf_acte.maitrise_fonciere='Convention de gestion') AS mf_acte_acquis
ON mf_generale.code_acte=mf_acte_acquis.code_acte;
