Merhaba arkadaşlar aşağıdaki kodda alım faturalarında alım iadeleri ve iptallerini düşmek istiyorum nasıl yapabiliriz acaba
SELECT LG_086_ITEMS.CODE AS [MALZEME KODU], LG_086_CLCARD.DEFINITION_ AS [CARI ADI],LG_086_01_INVOICE.FICHENO, LG_086_01_INVOICE.DATE_,
LG_086_01_STLINE.AMOUNT AS MIKTAR
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 INNER JOIN LG_086_CLCARD ON LG_086_01_INVOICE.CLIENTREF=LG_086_CLCARD.LOGICALREF
WHERE LG_086_01_INVOICE.GRPCODE='1'
