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