1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| SELECT Employe.Matricule, Employe.Soc, Employe.Nom, Employe.Prenom, Employe.Sexe, Employe.Panel, Employe.Actif, ListeSocietes.Libelle AS LibelleSociete, Etablissement.Ets, Section.Code AS CodeSection, ListeSections.Libelle AS LibelleSection, Classification.Code AS CodeClassification, ListeClassifications.Libelle AS LibelleClassification, ListeClassifications.Niveau, Statut.Libelle AS LibelleStatut, Pole_Technologique.Valeur AS PoleTechno, Site.Libelle AS LibelleSite, Contrat.Libelle AS LibelleContrat, ListeResponsables.Nom + ' ' + ListeResponsables.Prenom AS NomResponsable, Activite.Pourcentage AS TauxActivite
FROM Employe
INNER JOIN ListeSocietes ON Employe.Soc = ListeSocietes.Soc
INNER JOIN Etablissement ON Employe.Matricule = Etablissement.Matricule AND Employe.Soc = Etablissement.Soc
INNER JOIN Section ON Employe.Matricule = Section.Matricule AND Employe.Soc = Section.Soc
INNER JOIN ListeSections ON ListeSocietes.Soc = ListeSections.Soc AND Section.Soc = ListeSections.Soc AND Section.Code = ListeSections.Code
INNER JOIN Classification ON Employe.Matricule = Classification.Matricule AND Employe.Soc = Classification.Soc
INNER JOIN ListeClassifications ON ListeSocietes.Soc = ListeClassifications.Soc AND Classification.Soc = ListeClassifications.Soc AND Classification.Code = ListeClassifications.Code
INNER JOIN Statut ON Employe.Matricule = Statut.Matricule AND Employe.Soc = Statut.Soc
INNER JOIN Pole_Technologique ON Employe.Matricule = Pole_Technologique.Matricule AND Employe.Soc = Pole_Technologique.Soc
INNER JOIN Site ON Employe.Matricule = Site.Matricule AND Employe.Soc = Site.Soc
INNER JOIN Contrat ON Employe.Matricule = Contrat.Matricule AND Employe.Soc = Contrat.Soc
INNER JOIN Responsable ON Employe.Matricule = Responsable.Matricule AND Employe.Soc = Responsable.Soc
INNER JOIN ListeResponsables ON ListeSocietes.Soc = ListeResponsables.Soc AND Responsable.Soc = ListeResponsables.Soc AND Responsable.idResponsable = ListeResponsables.id
INNER JOIN Activite ON Employe.Matricule = Activite.Matricule AND Employe.Soc = Activite.Soc
WHERE (Etablissement.DatePeriode = '01/01/2010') AND (Section.DatePeriode = '01/01/2010') AND (Classification.DatePeriode = '01/01/2010') AND (Statut.DatePeriode = '01/01/2010') AND (Pole_Technologique.DatePeriode = '01/01/2010') AND (Site.DatePeriode = '01/01/2010') AND (Contrat.DatePeriode = '01/01/2010') AND (Responsable.DatePeriode = '01/01/2010') AND (Activite.DatePeriode = '01/01/2010') |
Partager