CREATE VIEW dbo.TUM_YILLAR_SATIS_ADETLERI
AS
SELECT        ITM.LOGICALREF,ITM.CODE AS OEM1, ITM.PRODUCERCODE AS OEM2, CONCAT(ITM.[NAME], ITM.[NAME3]) AS [NAME], SUM(QQ.AMOUNT) AS AMOUNT
FROM            ((SELECT        STOCKREF, SUM(AMOUNT) AS AMOUNT
                            FROM            [UNIVERSALDB].[dbo].LG_011_08_STLINE
                            WHERE        TRCODE IN (7, 8) AND LINETYPE = 0
                            GROUP BY STOCKREF)
                         UNION ALL
                         (SELECT        STOCKREF, SUM(AMOUNT) AS AMOUNT
                          FROM            [UNIVERSALDB].[dbo].LG_011_07_STLINE
                          WHERE        TRCODE IN (7, 8) AND LINETYPE = 0
                          GROUP BY STOCKREF)
UNION ALL
(SELECT        STOCKREF, SUM(AMOUNT) AS AMOUNT
 FROM            [UNIVERSALDB].[dbo].LG_011_06_STLINE
 WHERE        TRCODE IN (7, 8) AND LINETYPE = 0
 GROUP BY STOCKREF)
UNION ALL
(SELECT        STOCKREF, SUM(AMOUNT) AS AMOUNT
 FROM            [UNIVERSALDB].[dbo].LG_011_05_STLINE
 WHERE        TRCODE = 8 AND LINETYPE = 0
 GROUP BY STOCKREF)
UNION ALL
(SELECT        STOCKREF, SUM(AMOUNT) AS AMOUNT
 FROM            [UNIVERSALDB].[dbo].LG_011_04_STLINE
 WHERE        TRCODE = 8 AND LINETYPE = 0
 GROUP BY STOCKREF)
UNION ALL
(SELECT        STOCKREF, SUM(AMOUNT) AS AMOUNT
 FROM            [UNIVERSALDB].[dbo].LG_011_03_STLINE
 WHERE        TRCODE = 8 AND LINETYPE = 0
 GROUP BY STOCKREF)
UNION ALL
(SELECT        STOCKREF, SUM(AMOUNT) AS AMOUNT
 FROM            [UNIVERSALDB].[dbo].LG_011_02_STLINE
 WHERE        TRCODE = 8 AND LINETYPE = 0
 GROUP BY STOCKREF)
UNION ALL
(SELECT        STOCKREF, SUM(AMOUNT) AS AMOUNT
 FROM            [UNIVERSALDB].[dbo].LG_011_01_STLINE
 WHERE        TRCODE = 8 AND LINETYPE = 0
 GROUP BY STOCKREF)) QQ LEFT OUTER JOIN
LG_011_ITEMS AS ITM ON ITM.LOGICALREF = QQ.STOCKREF
GROUP BY ITM.LOGICALREF,ITM.CODE, ITM.PRODUCERCODE, ITM.[NAME], ITM.NAME3