select composition_bureau.bureau, president,president_suppleant,secretaire,
to_char(date_scrutin ,'DD/MM/YYYY') as date_scrutin,
scrutin.libelle as libelle, bureau.libelle as libelle_bureau
from &DB_PREFIXEcomposition_bureau inner join &DB_PREFIXEscrutin on scrutin.scrutin=composition_bureau.scrutin 
inner join &DB_PREFIXEbureau on bureau.bureau=composition_bureau.bureau
where composition_bureau.scrutin = '&idx' and composition_bureau.bureau ='&idz'