SELECT *
FROM formation
LEFT JOIN intervenant USING(intervenant_id)
WHERE formation_code = 'consultant-formateur'