TC 132/WG 7 Tôles, bandes et tôles épaisses
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) = 2718) AND ((Commissions.`Date Fin Com`) Is Null) AND ((Commissions.IdNatComm)<6) AND ((Commissions.`DateSommeil Com`) Is Null))