SELECT 
agents.matricule,
agents.prenom,
agents.nom,
agents.
FROM `membres_cooperative` INNER JOIN agents WHERE agents.matricule=membres_cooperative.matricule;