Voilà ... :
SELECT
aircraft_type_name, tank_label,
SUM(IF (month_num=1, quantity, 0)) AS Janu,
SUM(IF (month_num=2, quantity, 0)) AS Febr,
SUM(IF (month_num=3, quantity, 0)) AS Marc,
SUM(IF (month_num=4, quantity, 0)) AS Apri,
SUM(IF (month_num=5, quantity, 0)) AS Mai,
SUM(IF (month_num=6, quantity, 0)) AS June,
SUM(IF (month_num=7, quantity, 0)) AS Ju
Forum:
Evolutions et Adaptations