1 2 3 4 5 6 7 8 9
|
select codca, aut_deb, utl_debit, aut_com, utl_come, aut_fct, utl_fcte, aut_cmlt, utl_cmlte, aut_rsp, utl_rspe, aut_esg, utl_esge, impaye, mmm, smv , periode
from client
JOIN portefeuille
ON client.id=portefeuille.id
JOIN eng_dge@dbcg_bdpbc
on eng_dge.cpte= portefeuille.n_cpte
where periode = '31-oct.-2010'
group by codca , sum(aut_deb), sum(utl_debit), sum(aut_com), sum(utl_come), sum(aut_fct), sum(utl_fcte), sum(aut_cmlt), sum(utl_cmlte), sum(aut_rsp), sum(utl_rspe), sum(aut_esg), sum(utl_esge), sum(impaye), sum(mmm), sum(smv), periode ; |
Partager