Re: Jointure entre deux tabels

Publié par Manbiz le 28/10/2016 11:35:48

Merci à Tous
J'ai trouvé la solution:
WITH T AS
(
SELECT CASE WHEN i.Type_ID =1 THEN 'Carte identité'
WHEN i.Type_ID =2 THEN 'Passeport'
WHEN i.Type_ID =3 THEN 'Carte séjour' END as TYPDOC,
i.ID as NumID, C.Cod_Client, C.Montant,
ROW_NUMBER() OVER(PARTITION BY ID ORDER BY Type_ID) AS N
From Credit as C
LEFT OUTER JOIN ID_Client i on C.Cod_Client=i.Cod_Client
)
SELECT * FROM T WHERE N = 1;