CREATE VIEW dbo.CARI_AYLIK_TAKSITLI_CEKIM_SIFIR
AS
SELECT        CLIENTREF, MONTH_, SUM(TRNET) AS TUTAR
FROM            dbo.LG_011_06_CLFLINE
WHERE        (TRCODE = 70) AND (CANCELLED = 0) AND (LINEEXP LIKE '%TAKS%') AND (MONTH_ = 12)
GROUP BY CLIENTREF, MONTH_