SELECT
Personnel.nom AS nom,
Personnel.prénom AS prénom,
centres.Centre AS Centre,
Planning.date AS date,
Planning.gh1 AS gh1,
Planning.gh2 AS gh2,
Planning.gh3 AS gh3,
Qualification.qualification AS qualification
FROM
Personnel,
Planning,
centres,
Personnel_Qualification,
Qualification
WHERE
Personnel.IDPersonnel = Planning.IDPersonnel
AND centres.IDCentre = Personnel.IDCentre
AND Personnel.IDPersonnel = Personnel_Qualification.IDPersonnel
AND Qualification.IDQualification = Personnel_Qualification.IDQualification
AND
(
centres.Centre = {Param_cs}
AND Planning.date BETWEEN {Param_date_debut} AND {Param_date_fin}
AND Qualification.qualification = {Param_qualif}
)
Cette contribution était de : http://old.wdforge.org/newbb/viewtopic.php?forum=17&topic_id=4610&post_id=19128