hello,
This query is OK:
Select substr(Tbl_Session.Date, 1 , 4) AS Date,
sum(Case WHEN Tbl_Session.Type = 'type' THEN Tbl_Pois.Quantite end) as [TYPE 1],
sum(Case WHEN Tbl_Session.Type = 'type1' THEN Tbl_Pois.Quantite end) as [TYPE 2]
FROM (Tbl_Pois INNER JOIN Tbl_Session ON Tbl_Pois.Session_ID = Tbl_Session.ID_Session)
WHERE Tbl_Pois.Resultat = 'dig'
But this work when we know "Case WHEN Tbl_Session.Type = 'type'"
Now we don't know how much and what clause "Case WHEN Tbl_Session.Type = ????"
How to do?
Thanks
sorry my english is bad