
SELECT
  ('numero '||travaux||' '||entreprise.nomentreprise) as travaux,
  naturetravaux,
  to_char(datedebinter,'DD/MM/YYYY') as dates

FROM
  &DB_PREFIXEtravaux
  LEFT JOIN &DB_PREFIXEentreprise on travaux.entreprise=entreprise.entreprise

WHERE
  travaux.emplacement=&idx
;
