Sorguyu Çalıştırıp Sonucu yazarsanız.
WITH TABLOA
AS (SELECT '2016' FİRMA,
ITM.CODE,
ITM.NAME,
SUM(STL.AMOUNT) AS MİKTAR2016,
SUM(STL.LINENET) AS TUTAR2016
FROM dbo.LG_016_01_STLINE AS STL
INNER JOIN dbo.LG_016_ITEMS AS ITM
ON ITM.LOGICALREF = STL.STOCKREF
WHERE STL.TRCODE = 8
AND ITM.CARDTYPE = 1
GROUP BY ITM.NAME,
ITM.CODE
),
TABLOB
AS (SELECT '2015' FİRMA,
ITM.CODE,
ITM.NAME,
SUM(STL.AMOUNT) AS MİKTAR2015,
SUM(STL.LINENET) AS TUTAR2015
FROM dbo.LG_015_01_STLINE AS STL
INNER JOIN dbo.LG_015_ITEMS AS ITM
ON ITM.LOGICALREF = STL.STOCKREF
WHERE STL.TRCODE = 8 /*TOPTAN SATIŞ*/
AND ITM.CARDTYPE = 1
GROUP BY ITM.NAME,
ITM.CODE
)
SELECT TABLOA.CODE,
TABLOA.NAME,
TABLOA.MİKTAR2016,
TABLOB.MİKTAR2015,
TABLOA.TUTAR2016,
TABLOB.TUTAR2015,
TABLOA.TUTAR2016 - TABLOB.TUTAR2015 AS FARK
FROM TABLOA
INNER JOIN TABLOB
ON TABLOB.NAME = TABLOA.NAME;