select nom, prenom, adresse, agent.cp as cpagent, agent.ville as villeagent, candidature.scrutin,
scrutin.libelle as libellescrutin, 
to_char(date_scrutin ,'DD/MM/YYYY') as date_scrutin, 
candidature.poste, scrutin.convocation_agent,
candidature.bureau, bureau.libelle as libellebureau, candidature.periode, bureau.bureau, adresse1, adresse2, periode.libelle as libelleperiode
from &DB_PREFIXEagent inner join &DB_PREFIXEcandidature on agent.agent = candidature.agent  
inner join &DB_PREFIXEscrutin on candidature.scrutin=scrutin.scrutin
inner join &DB_PREFIXEbureau on bureau.bureau = candidature.bureau
left join &DB_PREFIXEperiode on candidature.periode=periode.periode
where candidature.scrutin='&idx'
  and decision is true