
SELECT
  (nom||' '||marital||' '||prenom||' concession '||famille||'('||emplacement.emplacement||')') 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
;
