
SELECT
  ('numero '||COALESCE(travaux,'0')||' '||COALESCE(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
;
