
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,
  autorisation.titre as ctitre,
  autorisation.nom as cnom,
  autorisation.prenom as cprenom,
  emplacement.numero as numero,
  cimetierelib,
  emplacement.complement as complement,
  voietype,
  voielib,
  zonelib

FROM
  &DB_PREFIXEdefunt 
  LEFT JOIN &DB_PREFIXEemplacement on defunt.emplacement=emplacement.emplacement
  LEFT JOIN &DB_PREFIXEautorisation on defunt.emplacement=autorisation.emplacement
  LEFT JOIN &DB_PREFIXEvoie on emplacement.voie=voie.voie 
  LEFT JOIN &DB_PREFIXEzone on voie.zone=zone.zone 
  LEFT JOIN &DB_PREFIXEcimetiere on zone.cimetiere=cimetiere.cimetiere  

WHERE
  autorisation.nature='concessionnaire'
  AND defunt.defunt=&idx
;