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

FROM
  &DB_PREFIXEautorisation

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