selam degerli hocalarım tekrar
selam degerli hocalarım bu sql sorgusunun
sonucunda adet toplamı almak istiyorum en son satıra
Adet
Topam xxxx
SELECT LG_105_ITEMS.NAME AS [Stok Aciklamasi], LG_105_01_GNTOTST.ONHAND AS Adet
FROM LG_105_ITEMS INNER JOIN
LG_105_01_GNTOTST ON LG_105_01_GNTOTST.STOCKREF = LG_105_ITEMS.LOGICALREF
WHERE (LG_105_ITEMS.CODE LIKE '%j%') AND (LG_105_01_GNTOTST.INVENNO = 0) AND (LG_105_01_GNTOTST.ONHAND > 0)
ORDER BY LG_105_01_GNTOTST.ONHAND