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
|
SELECT
ADRES.RUE1 AS RUE1,
ADRES.RUE2 AS RUE2,
ADRES.RUE3 AS RUE3,
ADRES.CODPOS AS CODPOS,
ADRES.BURDIS AS BURDIS,
BENEF.MATPROP AS MATPROP,
LEFT(BENEF.MATPROP,2) AS MATRICULE,
BENEF.NOM AS NOM,
BENEF.PRENOM AS PRENOM,
BENEF.DTCARTA AS DTCARTA,
BENEF.DTEADH AS DTEADH,
BENEF.NSS AS NSS,
BENEF.DTESOUS AS DTESOUS,
BENEF.DTNAIS AS DTNAIS,
BENEF.DTEDEBCART AS DTEDEBCART,
BENEF.DTEFINCART AS DTEFINCART,
BENEF.CLENSS AS CLENSS,
BENEF.NOCATEG AS NOCATEG,
BENEF.DTERAD AS DTERAD,
BENEF.QUALITE AS QUALITE,
LEFT(BENEF.MATPROP,8) AS Beneficiaire
FROM
BENEF LEFT OUTER JOIN ADRES ON BENEF.NSS=ADRES.NSS
WHERE
LEFT(BENEF.MATPROP,2) IN ({Param1})
AND BENEF.DTERAD = 0
ORDER BY
MATPROP ASC,
QUALITE ASC |
Partager