SELECT  concat(nom||' '||prenom|| ' '||adresse||' '||elu.cp||' '||elu.ville) as nom, 
 affectation.poste, 
 (affectation.bureau||' - '||bureau.libelle) as bureau 
 from  &DB_PREFIXEaffectation 
 inner join  &DB_PREFIXEelu on elu.elu=affectation.elu
 left join  &DB_PREFIXEbureau on bureau.bureau = affectation.bureau
 inner join  &DB_PREFIXEposte on affectation.poste = poste.poste
 where  affectation.scrutin = '&idx'  and decision is true 
order by affectation.bureau,poste.ordre