Selamlar aşağıdaki sorguyu kullanabilirsiniz.
SELECT
ITEMS.CODE ,
ITEMS.NAME,
(SELECT SUM(ONHAND) FROM LG_112_01_STINVTOT STINVTOT WHERE ITEMS.LOGICALREF=STINVTOT.STOCKREF AND INVENNO=-1) FIILI_STOK,
(SELECT SUM(ONHAND+TEMPOUT-RESERVED) FROM LG_112_01_STINVTOT STINVTOT WHERE ITEMS.LOGICALREF=STINVTOT.STOCKREF AND INVENNO=-1) GERCEK_STOK
FROM LG_112_ITEMS ITEMS