1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
| SELECT
b.QUALITE AS QUALITE,
b.MATPROP AS MATPROP,
b.NOM AS NOM,
b.PRENOM AS PRENOM,
b.DTCARTA AS DTCARTA,
b.DTEADH AS DTEADH,
b.DTESOUS AS DTESOUS,
b.NSS AS NSS,
b.DTNAIS AS DTNAIS,
b.DTEDEBCART AS DTEDEBCART,
b.DTEFINCART AS DTEFINCART,
b.CLENSS AS CLENSS,
b.NOCATEG AS NOCATEG,
ADRES.RUE1 AS RUE1,
ADRES.RUE2 AS RUE2,
ADRES.RUE3 AS RUE3,
ADRES.CODPOS AS CODPOS,
ADRES.BURDIS AS BURDIS,
b.Code AS Code,
b.Matri AS Matri
FROM
( SELECT
BENEF.QUALITE AS QUALITE,
BENEF.MATPROP AS MATPROP,
BENEF.NOM AS NOM,
BENEF.PRENOM AS PRENOM,
BENEF.DTCARTA AS DTCARTA,
BENEF.DTEADH AS DTEADH,
BENEF.DTESOUS AS DTESOUS,
BENEF.NSS AS NSS,
BENEF.DTNAIS AS DTNAIS,
BENEF.DTEDEBCART AS DTEDEBCART,
BENEF.DTEFINCART AS DTEFINCART,
BENEF.CLENSS AS CLENSS,
BENEF.NOCATEG AS NOCATEG,
LEFT(BENEF.MATPROP,2) AS Code,
LEFT(BENEF.MATPROP,8) AS Matri
FROM
BENEF
WHERE
LEFT(BENEF.MATPROP,2) IN ({Param1})
AND BENEF.DTERAD = 0
) AS b
INNER JOIN ADRES ON b.Matri = ADRES.MATRICULE
ORDER BY
MATPROP ASC,
QUALITE ASC |
Partager