Something

	SELECT sc.id_societe_composant ,sc.id_composant,sc.id_societe,cdf.fonction, MAX(scd.niveau )as max, scd.type					FROM societe_composant sc 					INNER JOIN composant_desordre_fonction cdf ON cdf.id_composant = sc.id_composant					INNER JOIN societe_composant_desordre scd ON sc.id_societe_composant = scd.id_societe_composant					GROUP BY  sc.id_societe,cdf.id_composant,fonction