Bonjour,
J'essaie désespérément d'adapter la requête (List of pilots who have flown less than X hours during last Y days)
qui se présente comme suit dans l'export generator:
SELECT CONCAT(au.last_name, ' ', au.first_name) AS pilot, TIME_FORMAT( SEC_TO_TIME( SUM(f.duration)*6 ), '%H:%i' ) AS total_time
FROM flight AS f
RIGHT JOIN flight_pilot AS fp ON fp.flight_id=f.id
LEFT JOIN aircraft
Forum:
Support client