
SELECT
  (titre||' '||nom||' '||prenom||' '||marital) as nom,
  (defunt_archive.nature||'  Taille :  '||taille) as nature,
  to_char(datenaissance,'DD/MM/YYYY') as datenaissance,
  to_char(dateinhumation,'DD/MM/YYYY') as dateinhumation,
  to_char(dateexhumation,'DD/MM/YYYY') as dateexhumation,
  to_char(datereduction,'DD/MM/YYYY') as datereduction,
  reduction,exhumation,
  historique, 
  (emplacement_archive.famille||'  n° :  '||emplacement_archive.emplacement) as emplacement,
  numeroacte, 
  to_char(datevente,'DD/MM/YYYY') as datevente,
  to_char(dateterme,'DD/MM/YYYY') as dateterme,
  duree,
  terme

FROM
  &DB_PREFIXEdefunt_archive
  LEFT JOIN &DB_PREFIXEemplacement_archive on emplacement_archive.emplacement=defunt_archive.emplacement

WHERE
  defunt=&idx
;