
SELECT
  (COALESCE(nom,'')||' '||COALESCE(marital,'')||' '||COALESCE(prenom,'')||' concession '||COALESCE(famille,'')||'('||COALESCE(emplacement.emplacement,'0')||')') as nom,
  to_char(datenaissance,'DD/MM/YYYY') as naissance,
  to_char(dateinhumation,'DD/MM/YYYY') as dateinhumation,
  defunt.nature,
  taille,
  reduction,
  exhumation

FROM
  &DB_PREFIXEdefunt
  LEFT JOIN &DB_PREFIXEemplacement on defunt.emplacement=emplacement.emplacement

WHERE
  emplacement.voie=&idx
;
