ARKADAŞLAR:
EXCELDE CARİ HAREKETLERİNİ TAHSİLAT-SATIŞ-FATURA ÇEKEBİLDİM FAKAT KREDİ KARTI ÖZEL KODUNU GETİRMİYOR TAHSİLATLARDA ÖZEL KODU TAHSİLAT YAPAN KİŞİ OLARAK TANIMLADIM ÇEK SENETİNKİNİDE GETİRİYOR FAKAT KREDİ KARTI FİŞİNİN ÖZEL KODUNU GETİRMİYOR SORGU :
SELECT LG_800_CLCARD.CODE, LG_800_CLCARD.DEFINITION_, LG_800_01_CLFLINE.DATE_, LG_800_01_CLFLINE.TRCODE, LG_800_01_CLFLINE.AMOUNT, LG_800_01_CLTOTFIL.MONTH_, LG_800_01_CLFLINE.SIGN, LG_800_01_CLFLINE.SPECODE
FROM LKSDB.dbo.LG_800_01_CLFLINE LG_800_01_CLFLINE, LKSDB.dbo.LG_800_01_CLTOTFIL LG_800_01_CLTOTFIL, LKSDB.dbo.LG_800_CLCARD LG_800_CLCARD
WHERE LG_800_01_CLFLINE.CLIENTREF = LG_800_CLCARD.LOGICALREF AND LG_800_01_CLTOTFIL.CARDREF = LG_800_CLCARD.LOGICALREF AND LG_800_01_CLTOTFIL.MONTH_ = LG_800_01_CLFLINE.MONTH_