SELECT
  famille,
  numero,
  complement,
  voie_type.libelle as  voietype,
  voielib,
  zone_type.libelle as zonetype,
  zonelib,
  cimetierelib,
  placeconstat,
  dateconstat,
  nombreplace,
  placeoccupe

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