Conversion access et mysql

Bonjour et merci davance
J'ai cette requête access que je voufrais transfomer en mysql. Quelqu'un pourrait me la convertir ?

Code:

---

1 2 3 4

SELECT reservation.datereserv, IIf([heure]=[heurereserv],[heurereserv],"") AS horaires, IIf([heure]=[heurereserv],[type],"") AS formation FROM reservation, jour, horaire GROUP BY reservation.datereserv, IIf([heure]=[heurereserv],[heurereserv],""), IIf([heure]=[heurereserv],[type],""), horaire.heure, reservation.heurereserv, reservation.type ORDER BY reservation.datereserv, reservation.heurereserv;

---