CREATE VIEW dbo.SON_IKI_YILIN_SATIS_TOPLAMLARI
AS
SELECT   QQ.STOCKREF, SUM(QQ.AMOUNT) AS SATIS, SUM(LINENET) AS TUTAR, YEAR_ AS YIL
FROM         ((SELECT   STOCKREF, DATE_, AMOUNT, LINENET+VATAMNT AS LINENET, YEAR_
                            FROM         [UNIVERSALDB].[dbo].LG_011_07_STLINE
                            WHERE     CANCELLED = 0 AND TRCODE = 8 AND LINETYPE = 0)
                         UNION ALL
                         (SELECT   STOCKREF, DATE_, AMOUNT, LINENET+VATAMNT AS LINENET, YEAR_
                          FROM         [UNIVERSALDB].[dbo].LG_011_06_STLINE
                          WHERE     CANCELLED = 0 AND TRCODE = 8 AND LINETYPE = 0)) QQ
GROUP BY QQ.STOCKREF, QQ.YEAR_