TC 131/SC 5 Appareils de régulation et de distribution et leurs composants

SELECT Commissions.IdCommission, Commissions.`Code Commission`, Commissions.`Nom Commission`, InstancesCENISO.IdCenIso, InstancesCENISO.`Ref CenIso`, InstancesCENISO.IdOrgaNorm FROM (TypeFilière INNER JOIN InstancesCENISO ON TypeFilière.IdFilière = InstancesCENISO.IdFilière) INNER JOIN (Commissions INNER JOIN InstancesCENISOSuivies ON Commissions.IdCommission = InstancesCENISOSuivies.IdCommission) ON InstancesCENISO.IdCenIso = InstancesCENISOSuivies.IdCenIso WHERE (((InstancesCENISO.IdCenIso) = 32) AND ((Commissions.`Date Fin Com`) Is Null) AND ((Commissions.IdNatComm)<6) AND ((Commissions.`DateSommeil Com`) Is Null))