12345678 |
- select * from (
- select hedef as kod,c.cari_isim as cari_isim,
- sum(case when ftip='G' then round(geneltoplam,2) else (-1*round(geneltoplam,2)) end) as tutar
- from fatura as f
- inner join tblcasabit as c on f.hedef=c.cari_kod
- inner join tblcasabit as cx on f.kaynak=cx.cari_kod
- where cx.grup_kodu='@kaynak@' AND c.cari_tip='F' and c.rapor_kodu1='takip_per'
- group by hedef ORDER BY tutar desc ) as t
|