SELECT LG_086_01_INVOICE.DATE_ AS Tarih, LG_086_01_INVOICE.TRCODE AS [Fatura Türü], LG_086_01_INVOICE.FICHENO AS [Fiş No],
LG_086_01_INVOICE.DOCODE AS [Belge No], LG_086_ITEMS.CODE AS [Stok Kodu], LG_086_ITEMS.NAME AS [Stok Açıklaması],
LG_086_01_STLINE.AMOUNT AS Miktar, LG_086_01_STLINE.PRICE AS Fiyat, LG_086_01_STLINE.TOTAL AS Tutar,
LG_086_01_STLINE.DISTDISC AS [İndirim tutarı]
FROM LG_086_ITEMS INNER JOIN
LG_086_01_STLINE ON LG_086_ITEMS.LOGICALREF = LG_086_01_STLINE.STOCKREF INNER JOIN
LG_086_01_INVOICE ON LG_086_01_STLINE.INVOICEREF = LG_086_01_INVOICE.LOGICALREF
WHERE (LG_086_01_INVOICE.FICHENO = '00057241')