1 2
| SELECT Employes.Matricule, Filiales.NomFiliale, Employes.NomEmploye, Employes.PrenomEmploye, Conges.DebutConge, Services.LibelleService,Conges.IdConge, Conges.traité FROM Services INNER JOIN (Filiales INNER JOIN (Employes INNER JOIN Conges ON Employes.Matricule = Conges.Matricule) ON Filiales.IdFiliales = Employes.IdFiliale) ON Services.IdService = Employes.IdService
WHERE Conges.DebutConge<= (Day(date()) & " / " & Month(date()) + 1 & " / " & Year(date())) AND (Conges.DebutConge)>= date()+15 AND Employes.Etat= true AND Conges.traité=false; |
Partager