----------
SELECT
CSCARD.PORTFOYNO AS 'Portföy Numarası',
CSCARD.SERINO 'Seri Numarası',
CSCARD.DUEDATE AS 'Vade',
CSCARD.AMOUNT AS 'Tutar',
CSTRANS.DATE_ AS 'Tarih',
CSCARD.BANKNAME AS 'Bankası',
CLCARD.CODE AS 'C/H Kodu',
CLCARD.DEFINITION_ AS 'C/H Ünvanı'
FROM LG_001_01_CSCARD CSCARD,LG_001_01_CSTRANS CSTRANS,LG_001_CLCARD CLCARD
WHERE CSTRANS.CSREF = CSCARD.LOGICALREF AND CSTRANS.CARDREF = CLCARD.LOGICALREF AND
((CSCARD.DOC=1) AND (CSCARD.CURRSTAT=2) AND (CSTRANS.STATNO=1) AND
DATE_<='01.01.2007')ORDER BY CSCARD.PORTFOYNO
--------
firma ve dönem numarasını değiştirmeyi unutmayınız.