voila la requete :
select distinct [T_MATERIEL].[MATERIEL_REF], [T_COMPOSE].[MATERIEL_ID], [T_COMPOSE].[T_M_MATERIEL_ID]
from [T_MATERIEL],[T_COMPOSE]
where [T_COMPOSE].[MATERIEL_ID] =...