1 2 3
| SELECT DISTINCT T_sogecarte.[identifiant salarié], First(T_sogecarte.[numero carte]) AS [numero carte], First(T_sogecarte.[civilité titulaire]) AS [civilité titulaire], First(T_sogecarte.[nom titulaire]) AS [nom titulaire], First(T_sogecarte.[prénom titulaire]) AS [prénom titulaire], First(T_sogecarte.échéance) AS échéance, First(T_sogecarte.[état carte]) AS [état carte], First(T_sogecarte.[numero contrat]) AS [numero contrat], First(T_sogecarte.Email_address) AS Email_address, First(T_sogecarte.RC_Local_ID) AS RC_Local_ID, First(T_sogecarte.RC_Local_sigle) AS RC_Local_sigle, First(T_sogecarte.Employee_Status_Desc) AS Employee_Status_Desc, First(T_sogecarte.[Numéro de prestation]) AS [Numéro de prestation], First(T_sogecarte.BU_SU) AS BU_SU, First(T_sogecarte.S_BU_SU) AS S_BU_SU, [identifiant salarié] & [numero carte] AS cle_concatener
FROM T_sogecarte
GROUP BY T_sogecarte.[identifiant salarié], [identifiant salarié] & [numero carte]; |
Partager