select
service.libelle||' '||to_char(date_envoi,'DD/MM/YYYY')  as envoi,
avis_consultation.libelle||' du '||to_char(date_retour,'DD/MM/YYYY')  as retour,
to_char(date_limite,'DD/MM/YYYY')  as limite
from &DB_PREFIXEconsultation inner join &DB_PREFIXEservice on service.service = consultation.service
left join &DB_PREFIXEavis_consultation on avis_consultation.avis_consultation=consultation.avis_consultation
where consultation.dossier = '&idx'