SELECT (elu.nom||' '||elu.prenom||'    '||elu.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
 inner join  &DB_PREFIXEbureau on bureau.bureau = affectation.bureau
where  affectation.scrutin = '&idx'  and (poste = 'PRESIDENT' or poste ='PRESIDENT SUPPLEANT') and decision is true
order by affectation.bureau,affectation.poste