Z Rapor Sorgusu

[ismailayan]

select distinct (tb_alisveris.kasakodu) as Kasa,
sum(isnull(tb_alisveris.miktar,0)) as ToplamMiktar,
sum(isnull(tb_alisveris.tutar,0)) as ToplamTutar,
sum(case when tb_alisveris.odemetipi='N' and tb_alisveris.kasakodu='k002' then tb_alisveris.tutar else 0 end) as NakitToplam,
sum(case when tb_alisveris.odemetipi='KK' and tb_alisveris.kasakodu='k002' then tb_alisveris.tutar else 0 end) as KrediKartiToplam,
sum(case when tb_alisveris.odemetipi='N' and tb_alisveris.kasakodu='k002' then tb_alisveris.tutar else 0 end)+sum(case when tb_alisveris.odemetipi='KK' and tb_alisveris.kasakodu='k002' then tb_alisveris.tutar else 0 end) as OdemeToplami,
(select sum(isnull(tb_masraf.tutar,0)) from tb_masraf where kasakodu='k002' and ftarihi between '03/09/2008' and '03/09/2008') as MasrafToplam,
(SELECT sum(isnull(tb_avans.avtutar,0)) from tb_avans where kasakodu='k002' and avtarih between '03/09/2008' and '03/09/2008') as AvansToplam,
(select sum(isnull(tb_masraf.tutar,0)) from tb_masraf where kasakodu='k002' and ftarihi between '03/09/2008' and '03/09/2008') +
(SELECT sum(isnull(tb_avans.avtutar,0)) from tb_avans where kasakodu='k002' and avtarih between '03/09/2008' and '03/09/2008') as KasaCikisToplami,
sum(case when tb_alisveris.odemetipi='N' and tb_alisveris.kasakodu='k002' then tb_alisveris.tutar else 0 end)+sum(case when tb_alisveris.odemetipi='KK' and tb_alisveris.kasakodu='k002' then tb_alisveris.tutar else 0 end)-
(SELECT sum(isnull(tb_avans.avtutar,0)) from tb_avans where kasakodu='k002' and avtarih between '03/09/2008' and '03/09/2008')-
(select sum(isnull(tb_masraf.tutar,0)) from tb_masraf where kasakodu='k002' and ftarihi between '03/09/2008' and '03/09/2008') as NetKasa
from tb_alisveris where tb_alisveris.kasakodu='k002' and tb_alisveris.faturatarihi between '03/09/2008' and '03/09/2008'
group by tb_alisveris.kasakodu

burda KasaCikisToplami masraf ile avansın toplamını alması gerekiyor..
ama taoplama işlemini yapmıyor

bu konudayardımcı olurmusunuz?