Yazdığım şu kod da işinize yarayabilir.
SELECT
Stok.STGRPCODE AS [Stok Grup Kodu],
BAR.BARCODE As Barkodu,
Stok.CODE As Kodu,
Stok.NAME As ADI,
Stok.VAT As KDV,
ISNULL((SELECT TOP 1 Fiyat.PRICE FROM LG_114_PRCLIST AS Fiyat WITH(NOLOCK) WHERE Fiyat.PTYPE=1 AND PRIORITY=1 AND Fiyat.CARDREF=Stok.LOGICALREF),0) AS [Alış Fiyatı],
ISNULL((SELECT TOP 1 Fiyat.PRICE FROM LG_114_PRCLIST AS Fiyat WITH(NOLOCK) WHERE Fiyat.PTYPE=2 AND PRIORITY=1 AND Fiyat.CARDREF=Stok.LOGICALREF),0) AS [Satış Fiyatı],
ISNULL((SELECT ONHAND FROM LV_114_01_GNTOTST AS M WITH(NOLOCK) WHERE M.INVENNO=-1 AND M.STOCKREF=Stok.LOGICALREF),0) AS STOK,
Stok.SPECODE,
Stok.SPECODE2,
Stok.SPECODE3,
Stok.SPECODE4,
Stok.SPECODE5
FROM
LG_114_ITEMS AS Stok INNER JOIN
LG_114_PRCLIST As Fiyat ON Stok.LOGICALREF = Fiyat.CARDREF INNER JOIN
LG_114_UNITBARCODE As BAR ON Stok.LOGICALREF = BAR.ITEMREF INNER JOIN
LG_114_01_STLINE AS HRK ON Stok.LOGICALREF=HRK.STOCKREF
GROUP BY
Fiyat.PTYPE,
Fiyat.PRICE,
Stok.LOGICALREF,
Stok.STGRPCODE,
Stok.CODE,
Stok.NAME,
BAR.BARCODE,
Stok.VAT,
Stok.SPECODE,
Stok.SPECODE2,
Stok.SPECODE3,
Stok.SPECODE4,
Stok.SPECODE5