SELECT
    commission_type.libelle,
    commission.code,
    TO_CHAR(commission.date_commission,'DD/MM/YYYY') as date_commission,
    dossier_commission.avis
FROM &DB_PREFIXEdossier_commission
LEFT JOIN &DB_PREFIXEcommission
ON
dossier_commission.commission = commission.commission
LEFT JOIN &DB_PREFIXEcommission_type
ON
commission.commission_type = commission_type.commission_type
WHERE dossier_commission.dossier = '&idx' and dossier_commission.commission IS NOT NULL