1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| SELECT DISTINCT Machin_aff.AffStruct_NomCourt AS Unite_Responsabilite_Machin, type_compte.Origine_Personne,
Machin_emp.Employe_CodeEmploye, Machin_emp.Employe_Nom, Machin_emp.Employe_Prenom, Machin_emp.Employe_Debut,
Machin_emp.Employe_Fin, Machin_emp.Employe_Statut, Machin_user.User_Login, Machin_user.User_Debut, Machin_user.User_Fin,
Machin_user.User_Actif AS User_NonVerrouille, roles_concatenes.Roles, Machin_aff.AffStruct_NomCourt,
Machin_aff.AffStruct_BrisdeGlace, Machin_aff.AffStruct_Debut, Machin_aff.AffStruct_Fin,
aff_struct_concatenee.Affectations_Structure AS Liste_Aff_Struct_Actives,
aff_struct_concatenee_bg.Affectations_Structure AS Liste_Aff_Struct_BG_Actives, Truc_resultat_all.UNI_UF,
Truc_resultat_all.UNI_UG, Truc_resultat_all.UNI_LIBELLE, Truc_resultat_all.AFF_DATE_DEBUT,
Truc_resultat_all.AFF_DATE_FIN, Truc_resultat_all.PRO_LIBELLE
FROM
(((type_compte INNER JOIN
(((Truc_resultat_all RIGHT JOIN Machin_emp ON Truc_resultat_all.EMP_MATRICULE_COURT = Machin_emp.Employe_CodeEmploye) LEFT JOIN aff_struct_concatenee ON Machin_emp.Employe_IDMachin = aff_struct_concatenee.Employe_IDMachin
) LEFT JOIN aff_struct_concatenee_bg ON Machin_emp.Employe_IDMachin = aff_struct_concatenee_bg.Employe_IDMachin
) ON type_compte.Employe_IDMachin = Machin_emp.Employe_IDMachin
) LEFT JOIN Machin_aff ON Machin_emp.Employe_IDMachin = Machin_aff.Employe_IDMachin
) LEFT JOIN Machin_user ON Machin_emp.Employe_IDMachin = Machin_user.Employe_IDMachin
) LEFT JOIN roles_concatenes ON Machin_user.User_IDMachin = roles_concatenes.User_IDMachin
WHERE
(Machin_emp.Employe_Fin Is Null Or Machin_emp.Employe_Fin>Now()) AND
(Machin_user.User_Fin Is Null Or Machin_user.User_Fin>Now()) AND
Machin_aff.AffStruct_NomCourt Like "087%" AND
(Machin_aff.AffStruct_Fin Is Null Or Machin_aff.AffStruct_Fin>Now()) AND
LENGTH(AffStruct_NomCourt)=6; |
Partager