SELECT (elu.nom||' '||elu.prenom ) as nom, (affectation.poste||' '||coalesce(affectation.bureau,'')) as poste, candidat.nom as candidat from &DB_PREFIXEaffectation inner join &DB_PREFIXEelu on elu.elu=affectation.elu left join &DB_PREFIXEcandidat on candidat.candidat=affectation.candidat left join &DB_PREFIXEbureau on bureau.bureau = affectation.bureau inner join &DB_PREFIXEposte on affectation.poste = poste.poste where affectation.scrutin='&idx' and (affectation.bureau='&idz' or affectation.bureau = 'T') and affectation.poste not like 'PRESIDENT%' and decision is true order by affectation.bureau,poste.ordre,candidat