Firma bilgilerini düzenleyip Deneyebilirsin.
Ayrıca ben Toptan satış için yaptım..Sen kendine göre uyarla
WITH TABLOA
AS ( SELECT '2016' FİRMA ,
ITM.STGRPCODE ,
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.STGRPCODE
),
TABLOB
AS ( SELECT '2015' FİRMA ,
ITM.STGRPCODE ,
SUM(STL.LINENET) AS TUTAR2015
FROM dbo.LG_065_01_STLINE AS STL
INNER JOIN dbo.LG_065_ITEMS AS ITM ON ITM.LOGICALREF = STL.STOCKREF
WHERE STL.TRCODE = 8 /*TOPTAN SATIŞ*/
AND ITM.CARDTYPE = 1
GROUP BY ITM.STGRPCODE
)
SELECT TABLOA.STGRPCODE ,
TABLOA.TUTAR2016 ,
TABLOB.TUTAR2015 ,
TABLOA.TUTAR2016 - TABLOB.TUTAR2015 AS FARK
FROM TABLOA
INNER JOIN TABLOB ON TABLOB.STGRPCODE = TABLOA.STGRPCODE;