SELECT ITM.CODE KOD,ITM.NAME AS 'ÜRÜN ADI',TOT.ONHAND MİKTAR, (SELECT TOP 1 (TOTAL-DISTCOST)/AMOUNT FROM LG_002_03_STLINE WHERE STOCKREF=ITM.LOGICALREF AND (TRCODE=1 or (TRCODE=14 and BILLED=0) )AND LPRODSTAT=0 AND LINETYPE=0 ORDER BY DATE_ DESC ) FİYATI, TOT.ONHAND*(SELECT TOP 1 (TOTAL-DISTCOST)/AMOUNT FROM LG_002_03_STLINE WHERE STOCKREF=ITM.LOGICALREF AND (TRCODE=1 or (TRCODE=14 and BILLED=0) )AND LPRODSTAT=0 AND LINETYPE=0 ORDER BY DATE_ DESC ) TUTAR FROM LG_002_03_GNTOTST TOT INNER JOIN LG_002_ITEMS ITM ON ITM.LOGICALREF=TOT.STOCKREF WHERE TOT.INVENNO=-1 ORDER BY ITM.CODE