ActivitésLeadership international

TC 459/SC 9/WG 2 Aciers pour emballages

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) = 2315) AND ((Commissions.`Date Fin Com`) Is Null) AND ((Commissions.IdNatComm)<6) AND ((Commissions.`DateSommeil Com`) Is Null))