
SELECT
  (nom||' '||prenom||' '||marital) as nom,
  (adresse1||' '||adresse2||' '||cp||' '||ville) as adresse,
  marital

FROM
  &DB_PREFIXEautorisation_archive

WHERE
  emplacement=&idx
  AND nature='concessionnaire'
;
