Je crois bien avoir réussi ma requête! (ça reste à confirmer)
Voilà de quoi elle a l'air:
Merci beaucoup à vous!!!!!
Voilà de quoi elle a l'air:
SELECT
Granulos.C112 AS 112,
Granulos.C80 AS 80,
Granulos.C56 AS 56,
Granulos.C40 AS 40,
Granulos.C31_5 AS [31,5],
Granulos.C28 AS 28,
Granulos.C20 AS 20,
Granulos.C14 AS 14,
Granulos.C10 AS 10,
Granulos.C5 AS 5,
Granulos.C2_5 AS [2,5],
Granulos.C1_25 AS [1,25],
Granulos.C630 AS [0,630],
Granulos.C315 AS [0,315],
Granulos.C160 AS [0,160],
Granulos.C80m AS [0,080]
FROM
tblGranulatsResultats AS Granulos
INNER JOIN
tblGranulatInfos AS J1Infos
ON J1Infos.analyse = Granulos.analyse
WHERE
Granulos.analyse = 1
UNION
SELECT
Exigences.EX112MIN AS 112,
Exigences.EX80MIN AS 80,
Exigences.EX56MIN AS 56,
Exigences.EX40MIN AS 40,
Exigences.EX31_5MIN AS [31,5],
Exigences.EX28MIN AS 28,
Exigences.EX20MIN AS 20,
Exigences.EX14MIN AS 14,
Exigences.EX10MIN AS 10,
Exigences.EX5MIN AS 5,
Exigences.EX2_5MIN AS [2,5],
Exigences.EX1_25MIN AS [1,25],
Exigences.EX630MIN AS [0,630],
Exigences.EX315MIN AS [0,315],
Exigences.EX160MIN AS [0,160],
Exigences.EX80MMIN AS [0,080]
FROM
tblGranulatExigences AS Exigences,
tblGranulatsResultats AS Granulos
INNER JOIN
tblGranulatInfos AS J2Infos
ON J2Infos.analyse = Granulos.analyse
WHERE
Exigences.ID_Exigence = J2Infos.Exig_No
AND
Granulos.analyse = 1
UNION
SELECT
Exigences.EX112MAX AS 112,
Exigences.EX80MAX AS 80,
Exigences.EX56MAX AS 56,
Exigences.EX40MAX AS 40,
Exigences.EX31_5MAX AS [31,5],
Exigences.EX28MAX AS 28,
Exigences.EX20MAX AS 20,
Exigences.EX14MAX AS 14,
Exigences.EX10MAX AS 10,
Exigences.EX5MAX AS 5,
Exigences.EX2_5MAX AS [2,5],
Exigences.EX1_25MAX AS [1,25],
Exigences.EX630MAX AS [0,630],
Exigences.EX315MAX AS [0,315],
Exigences.EX160MAX AS [0,160],
Exigences.EX80MMAX AS [0,080]
FROM
tblGranulatExigences AS Exigences,
tblGranulatsResultats AS Granulos
INNER JOIN
tblGranulatInfos AS J2Infos
ON J2Infos.analyse = Granulos.analyse
WHERE
Exigences.ID_Exigence = J2Infos.Exig_No
AND
Granulos.analyse = 1Merci beaucoup à vous!!!!!