CREATE VIEW dbo.PLAS_RAPOR_AYLIK_IADE_TOPLAM
AS
SELECT   QQ.YEAR_, QQ.MONTH_, QQ.LOGICALREF, QQ.PLS, SUM(QQ.TUTAR) AS TUTAR
FROM         ((SELECT   CLF.YEAR_, CLF.MONTH_, SLS.LOGICALREF, ISNULL(SLS.DEFINITION_, 'SIRKET') AS PLS, CLF.TRNET AS TUTAR
                            FROM         dbo.LG_011_08_CLFLINE AS CLF LEFT OUTER JOIN
                                                      dbo.LG_SLSMAN AS SLS ON CLF.SALESMANREF = SLS.LOGICALREF
                            WHERE     (CLF.TRCODE = 33) AND (CLF.CANCELLED = 0))
                         UNION ALL
                         (SELECT   CLF.YEAR_, CLF.MONTH_, SLS.LOGICALREF, ISNULL(SLS.DEFINITION_, 'SIRKET') AS PLS, CLF.TRNET AS TUTAR
                          FROM         dbo.LG_011_07_CLFLINE AS CLF LEFT OUTER JOIN
                                                    dbo.LG_SLSMAN AS SLS ON CLF.SALESMANREF = SLS.LOGICALREF
                          WHERE     (CLF.TRCODE = 33) AND (CLF.CANCELLED = 0))) QQ
GROUP BY QQ.YEAR_, QQ.MONTH_, QQ.PLS, QQ.LOGICALREF