Voici une correction (suppression de la clause HAVING) :
SELECT
ft.name AS Type_vol,
IF ((SELECT
COUNT(*)
FROM flight_pilot fp2
WHERE fp2.flight_id=fp.flight_id
AND fp2.num=1)=0, 'Solo', 'Double') AS DC,
CONCAT(FLOOR(SUM( duration )/600),':',TIME_FORMAT(SEC_TO_TIME((SUM( duration )/600 - FLOOR(SUM( duration )/600))*3600),'%i')) AS Total
Forum:
Support client