
SELECT
  famille,
  numero,
  complement,
  voietype,
  voielib,
  zonetype,
  zonelib,
  cimetierelib,
  placeconstat,
  dateconstat,
  nombreplace,
  placeoccupe

FROM
  &DB_PREFIXEemplacement
  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
  emplacement=&idx
;