1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| SELECT a.id_article
,MAX(CASE WHEN fk_critere = 1 THEN valeur END) AS v1
,MAX(CASE WHEN fk_critere = 2 THEN valeur END) AS v2
,MAX(CASE WHEN fk_critere = 3 THEN valeur END) AS v3
,MAX(CASE WHEN fk_critere = 4 THEN valeur END) AS v4
,MAX(CASE WHEN fk_critere = 5 THEN valeur END) AS v5
,MAX(CASE WHEN fk_critere = 6 THEN valeur END) AS v6
,MAX(CASE WHEN fk_critere = 7 THEN valeur END) AS v7
,MAX(CASE WHEN fk_critere = 8 THEN valeur END) AS v8
,MAX(CASE WHEN fk_critere = 9 THEN valeur END) AS v9
,MAX(CASE WHEN fk_critere = 10 THEN valeur END) AS v10
,MAX(CASE WHEN fk_critere = 11 THEN valeur END) AS v11
,MAX(CASE WHEN fk_critere = 12 THEN valeur END) AS v12
,MAX(CASE WHEN fk_critere = 13 THEN valeur END) AS v13
,MAX(CASE WHEN fk_critere = 14 THEN valeur END) AS v14
,MAX(CASE WHEN fk_critere = 15 THEN valeur END) AS v15
FROM article a
LEFT JOIN valeurcritere v
ON v.fk_article = a.id_article AND fk_critere in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15)
GROUP BY a.id_article |
Partager