SELECT ITM.CODE KOD,ITM.NAME AS 'ÜRÜN ADI',SUM(TOT.ONHAND) MİKTAR,
(SELECT TOP 1 (TOTAL-DISTCOST)/AMOUNT FROM LG_005_01_STLINE WHERE STOCKREF=ITM.LOGICALREF AND
(TRCODE=1 or (TRCODE=13 and BILLED=0) )AND LPRODSTAT=0 AND LINETYPE=0 ORDER BY DATE_ DESC ) FİYATI
FROM Lv_005_01_STINVTOT TOT INNER JOIN LG_005_ITEMS ITM ON ITM.LOGICALREF=TOT.STOCKREF
WHERE TOT.INVENNO=-1 AND ITM.CODE BETWEEN '151.000' AND '151.910'
GROUP BY ITM.CODE,ITM.NAME,ITM.LOGICALREF ORDER BY ITM.CODE
bu sorgu sql management studio express te çalışıyor ama excel aktarmak istediğimde hata veriyor ne yapmama lazım
hata mesajı ekteki dosyada