SELECT LG_001_ITEMS.CODE, LG_001_ITEMS.NAME, LG_001_01_STLINE.AMOUNT, LG_001_01_STLINE.LINENET, LG_001_01_STLINE.DATE_, LG_001_CLCARD.CODE, LG_001_CLCARD.DEFINITION_
FROM LKSDB1.dbo.LG_001_01_INVOICE LG_001_01_INVOICE, LKSDB1.dbo.LG_001_01_STLINE LG_001_01_STLINE, LKSDB1.dbo.LG_001_CLCARD LG_001_CLCARD, LKSDB1.dbo.LG_001_ITEMS LG_001_ITEMS
WHERE LG_001_01_STLINE.INVOICEREF = LG_001_01_INVOICE.LOGICALREF AND LG_001_01_STLINE.STOCKREF = LG_001_ITEMS.LOGICALREF AND LG_001_01_INVOICE.CLIENTREF = LG_001_CLCARD.LOGICALREF
Sanırım bu size yardımcı olabilir.
İlgili SQL cümlesini query 'den sorgulamadan önce 001 yazan yerlere kendi firma numaranızı yazmayı, LKSDB1 yazan yerede kendi DATABASE isminizi yazmayı unutmayın...
