CREATE VIEW dbo.SON_IKI_YILIN_SATIS_TOPLAMLARI_ORTAK
AS
SELECT   QQ.STOCKREF, SUM(QQ.AMOUNT) AS SATIS, SUM(LINENET) AS TUTAR
FROM         ((SELECT   STOCKREF, DATE_, AMOUNT, LINENET+VATAMNT AS LINENET
                            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
                          FROM         [UNIVERSALDB].[dbo].LG_011_06_STLINE
                          WHERE     CANCELLED = 0 AND TRCODE = 8 AND LINETYPE = 0)) QQ
GROUP BY QQ.STOCKREF