
SELECT
  voie,
  voietype,
  voielib,
  zonetype,
  zonelib,
  cimetierelib

FROM
  &DB_PREFIXEvoie
  LEFT JOIN &DB_PREFIXEzone on voie.zone=zone.zone 
  LEFT JOIN &DB_PREFIXEcimetiere on  zone.cimetiere=cimetiere.cimetiere

WHERE
  voie=&idx
;