Testez celle-ci et dîtes-moi si c'est bien ce que vous vouliez :
SELECT member_pool.name as Pool,
CONCAT(last_name,' ',first_name) AS Nom,
IF (( SELECT
COUNT(*)
FROM flight_pilot fp2
WHERE fp2.flight_id=fp.flight_id AND fp2.num=1)=0,
'Solo',
'double') AS Solo_DC,
CONCAT(FLOOR(SUM( flight.duration )/600),':',TIME_FORMAT(SEC_TO_TIME((SUM( flight.duration )/600 - FLOOR(SUM( flight.duratio
Forum:
Support client