select nom, prenom, adresse, elu.cp as cpelu, elu.ville as villeelu, affectation.scrutin,
scrutin.libelle as libellescrutin, 
to_char(date_scrutin ,'DD/MM/YYYY') as date_scrutin,  scrutin.convocation_president,
affectation.bureau, bureau.libelle as libellebureau, bureau.bureau,
bureau.adresse1, bureau.adresse2
from  &DB_PREFIXEelu inner join  &DB_PREFIXEaffectation on elu.elu = affectation.elu  
inner join  &DB_PREFIXEscrutin on affectation.scrutin=scrutin.scrutin
inner join  &DB_PREFIXEbureau on bureau.bureau = affectation.bureau
where affectation.scrutin='&idx' 