CREATE VIEW dbo.CARI_AYLIK_SATISLAR_SIFIR
AS
SELECT        QQ.CLIENTREF, QQ.MONTH_, SUM(QQ.SATIS) AS SATIS, SUM(QQ.IADE) AS IADE, SUM(QQ.SATIS) - SUM(QQ.IADE) AS TUTAR
FROM            ((SELECT        CLIENTREF, MONTH_, SUM(TRNET) AS [SATIS], 0 AS IADE
                            FROM            LG_011_06_CLFLINE
                            WHERE        TRCODE = 38 AND CANCELLED = 0 AND MONTH_ = 12
                            GROUP BY CLIENTREF, MONTH_)
                         UNION ALL
                         (SELECT        CLIENTREF, MONTH_, 0 AS SATIS, SUM(TRNET) AS [IADE]
                          FROM            LG_011_06_CLFLINE
                          WHERE        TRCODE = 33 AND CANCELLED = 0 AND MONTH_ = 12
                          GROUP BY CLIENTREF, MONTH_)) QQ
GROUP BY QQ.CLIENTREF, QQ.MONTH_