CREATE VIEW dbo.CARI_TUM_ISLEM_TOPLAMLARI
AS
SELECT * FROM 
(
(SELECT CLIENTREF, MONTH_, SUM(KKTEK) AS KKTEK, SUM(KKTAK) AS KKTAK, SUM(NAKIT) AS NAKIT, SUM(TOPODM) AS TOPODM, SUM(IADE) AS IADE, SUM(SATIS) AS SATIS, SUM(TOPSAT) AS TOPSAT, SUM(TOPODM)-SUM(TOPSAT) AS DURUM FROM
(
(SELECT CLIENTREF, 0 AS MONTH_, TUTAR AS KKTEK, 0 AS KKTAK, 0 AS NAKIT, 0 AS TOPODM, 0 AS IADE, 0 AS SATIS, 0 AS TOPSAT FROM dbo.CARI_AYLIK_TEK_CEKIM_SIFIR)
UNION ALL
(SELECT CLIENTREF, 0 AS MONTH_, 0 AS KKTEK, TUTAR AS KKTAK, 0 AS NAKIT, 0 AS TOPODM, 0 AS IADE, 0 AS SATIS, 0 AS TOPSAT FROM dbo.CARI_AYLIK_TAKSITLI_CEKIM_SIFIR)
UNION ALL
(SELECT CLIENTREF, 0 AS MONTH_, 0 AS KKTEK, 0 AS KKTAK, TUTAR AS NAKIT, 0 AS TOPODM, 0 AS IADE, 0 AS SATIS, 0 AS TOPSAT FROM dbo.CARI_AYLIK_NAKIT_ODEME_SIFIR)
UNION ALL
(SELECT CLIENTREF, 0 AS MONTH_, 0 AS KKTEK, 0 AS KKTAK, 0 AS NAKIT, TUTAR AS TOPODM, 0 AS IADE, 0 AS SATIS, 0 AS TOPSAT FROM dbo.CARI_AYLIK_TOPLAM_ODEME_SIFIR)
UNION ALL
(SELECT CLIENTREF, 0 AS MONTH_, 0 AS KKTEK, 0 AS KKTAK, 0 AS NAKIT, 0 AS TOPODM, IADE, SATIS, TUTAR AS TOPSAT FROM dbo.CARI_AYLIK_SATISLAR_SIFIR)
)QQ
GROUP BY QQ.CLIENTREF, QQ.MONTH_)
UNION ALL
(SELECT CLIENTREF, MONTH_, SUM(KKTEK) AS KKTEK, SUM(KKTAK) AS KKTAK, SUM(NAKIT) AS NAKIT, SUM(TOPODM) AS TOPODM, SUM(IADE) AS IADE, SUM(SATIS) AS SATIS, SUM(TOPSAT) AS TOPSAT, SUM(TOPODM)-SUM(TOPSAT) AS DURUM FROM
(
(SELECT CLIENTREF, MONTH_, TUTAR AS KKTEK, 0 AS KKTAK, 0 AS NAKIT, 0 AS TOPODM, 0 AS IADE, 0 AS SATIS, 0 AS TOPSAT FROM dbo.CARI_AYLIK_TEK_CEKIM)
UNION ALL
(SELECT CLIENTREF, MONTH_, 0 AS KKTEK, TUTAR AS KKTAK, 0 AS NAKIT, 0 AS TOPODM, 0 AS IADE, 0 AS SATIS, 0 AS TOPSAT FROM dbo.CARI_AYLIK_TAKSITLI_CEKIM)
UNION ALL
(SELECT CLIENTREF, MONTH_, 0 AS KKTEK, 0 AS KKTAK, TUTAR AS NAKIT, 0 AS TOPODM, 0 AS IADE, 0 AS SATIS, 0 AS TOPSAT FROM dbo.CARI_AYLIK_NAKIT_ODEME)
UNION ALL
(SELECT CLIENTREF, MONTH_, 0 AS KKTEK, 0 AS KKTAK, 0 AS NAKIT, TUTAR AS TOPODM, 0 AS IADE, 0 AS SATIS, 0 AS TOPSAT FROM dbo.CARI_AYLIK_TOPLAM_ODEME)
UNION ALL
(SELECT CLIENTREF, MONTH_, 0 AS KKTEK, 0 AS KKTAK, 0 AS NAKIT, 0 AS TOPODM, IADE, SATIS, TUTAR AS TOPSAT FROM dbo.CARI_AYLIK_SATISLAR)
)QQ
GROUP BY QQ.CLIENTREF, QQ.MONTH_)
)TT