select DATE_ AS 'FİŞ TARİHİ',BANK.DEFINITION_ AS 'BANKA HESAP', CLCARD.DEFINITION_ AS 'CARİ ÜNVANI',
CLFLINE.AMOUNT AS 'TUTAR'
from LG_002_02_CLFLINE CLFLINE, LG_002_BANKACC BANK, LG_002_CLCARD CLCARD
WHERE BANK.LOGICALREF=CLFLINE.BANKACCREF AND CLFLINE.CLIENTREF=CLCARD.LOGICALREF AND TRCODE=70