SELECT
  defunt.titre as dtitre,
  defunt.nom as dnom,
  defunt.prenom as dprenom,
  to_char(defunt.datenaissance,'DD/MM/YYYY') as datenaissance,
  to_char(defunt.datedeces,'DD/MM/YYYY') as datedeces,
  defunt.lieudeces as lieudeces,
  cimetierelib,
  emplacement.numero as numero,
  emplacement.complement as complement,
  voie_type.libelle as voietype,
  voielib,
  zone_type.libelle as zonetype,
  zonelib

FROM
  &DB_PREFIXEdefunt 
  LEFT JOIN &DB_PREFIXEemplacement on defunt.emplacement = emplacement.emplacement
  LEFT JOIN &DB_PREFIXEvoie on emplacement.voie = voie.voie
  LEFT JOIN &DB_PREFIXEvoie_type on voie.voietype = voie_type.voie_type
  LEFT JOIN &DB_PREFIXEzone on voie.zone = zone.zone
  LEFT JOIN &DB_PREFIXEzone_type on zone.zonetype = zone_type.zone_type
  LEFT JOIN &DB_PREFIXEcimetiere on zone.cimetiere = cimetiere.cimetiere

WHERE defunt.defunt=&idx
;