Selam,
Aşağıdaki sorgu işinize yarar mı ?
SELECT
KART.CODE 'Kodu',
KART.NAME 'Açıklama',
SUM(STOK.ONHAND) 'Mevcut',
SUM(STOK.AVGCURRVAL*STOK.ONHAND) 'ELDEKİLERİN ORT.MAL.RD'
FROM
LG_117_ITEMS KART LEFT JOIN
LV_117_01_GNTOTST STOK ON KART.LOGICALREF = STOK.STOCKREF
WHERE (STOK.INVENNO = - 1)
GROUP BY
KART.CODE,
KART.NAME
ORDER BY KART.CODE