1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
|
SELECT reqCoutRencontre.Nom, reqCoutRencontre.Prenom, reqCoutRencontre.Annees,
Sum(reqCoutRencontre.Montant) AS SommeDeMontant1, tblCommissions.Nom_Commission,
tblServices.Nom_Service AS Service1, tblServices_1.Nom_Service AS Service2,
tblServices_2.Nom_Service AS Service3, reqCoutRencontre.DR, reqCoutRencontre.Nom_Service AS Service
FROM tblServices AS tblServices_2 INNER JOIN ((tblCommissions INNER JOIN (tblServices AS tblServices_1 INNER JOIN
(tblServices INNER JOIN (reqCoutRencontre INNER JOIN tblPersonnes ON
reqCoutRencontre.ID_Personne = tblPersonnes.ID_Personne) ON tblServices.ID_Service = tblPersonnes.Service1_Personne)
ON tblServices_1.ID_Service = tblPersonnes.Service2_Personne) ON
tblCommissions.ID_Commission = tblPersonnes.Commission_Personne) INNER JOIN tblRencPers ON
tblPersonnes.ID_Personne = tblRencPers.ID_Personne) ON tblServices_2.ID_Service = tblPersonnes.Service3_Personne
GROUP BY reqCoutRencontre.Nom, reqCoutRencontre.Prenom, reqCoutRencontre.Annees, tblCommissions.Nom_Commission,
tblServices.Nom_Service, tblServices_1.Nom_Service, tblServices_2.Nom_Service, reqCoutRencontre.DR,
reqCoutRencontre.Nom_Service
ORDER BY tblCommissions.Nom_Commission; |
Partager