SELECT dbo.LG_010_CLCARD.CODE AS CariHesapKodu,
dbo.LG_010_CLCARD.DEFINITION_ AS CariHesapAciklamasi,
dbo.LG_010_CLCARD.SPECODE AS CariHesapOzelKodu,
dbo.LG_010_CLCARD.SPECODE2 as CariHesapOzelKodu2,
dbo.LG_010_ITEMS.CODE AS MalzemeKodu,
dbo.LG_010_ITEMS.NAME as MalzemeAciklamasi,
dbo.LG_010_ITEMS.SPECODE AS MalzemeOzelKodu,
dbo.LG_010_ITEMS.STGRPCODE AS MalzemeGrupKodu,
dbo.LG_010_01_STFICHE.DOCODE as FaturaNo,
dbo.LG_010_01_STFICHE.DATE_ as FaturaTarihi,
dbo.LG_010_01_STFICHE.SOURCEINDEX as Ambar,
dbo.LG_010_01_STLINE.AMOUNT AS Miktar,
dbo.LG_010_01_STLINE.PRICE AS BirimFiyat,
dbo.LG_010_01_STLINE.TOTAL AS Toplam,
dbo.LG_010_01_STLINE.VATMATRAH AS NetTutar,
dbo.LG_SLSMAN.DEFINITION_ AS SatisElemani,
dbo.LG_010_01_STFICHE.TRCODE as FaturaTuru
FROM
LG_010_01_STFICHE INNER JOIN
LG_010_01_STLINE ON LG_010_01_STLINE.STFICHEREF = LG_010_01_STFICHE.LOGICALREF INNER JOIN
LG_010_CLCARD ON LG_010_CLCARD.LOGICALREF=LG_010_01_STLINE.CLIENTREF INNER JOIN
LG_010_ITEMS ON LG_010_ITEMS.LOGICALREF=LG_010_01_STLINE.STOCKREF LEFT OUTER JOIN
LG_SLSMAN ON LG_SLSMAN.LOGICALREF=LG_010_01_STLINE.SALESMANREF
WHERE
dbo.LG_010_01_STLINE.LINETYPE=0 AND
LG_010_01_STFICHE.CANCELLED=0 AND
LG_010_01_STFICHE.TRCODE >= 7
ORDER BY dbo.LG_010_ITEMS.STGRPCODE