SQL Sorgu İade Çekler Raporu

SELECT CSC.SETDATE TARIH, DATEPART(WW,CSC.SETDATE)HAFTA,CSC.PORTFOYNO,CSR.ROLLNO BORDRONO,
    CSC.BANKNAME BANKA,CSC.DUEDATE CEKVADESI,CSC.AMOUNT TUTAR,
    (SELECT CURCODE FROM L_CURRENCYLIST WHERE FIRMNR=500 AND CURTYPE=CSC.TRCURR) DOVIZTIPI,
    CSC.TRNET DOVIZKARSILIGI,CSC.TRRATE DOVIZKURU,CSC.NEWSERINO CEKNO, CSC.OWING BORCLU,
    (SELECT CODE + ' - '+DEFINITION_ FROM LG_500_CLCARD WHERE LOGICALREF=
    (SELECT CARDREF FROM LG_500_01_CSTRANS WHERE TRCODE=1 AND CSREF=CSC.LOGICALREF AND CARDMD=5))CARISI,
    CST.DATE_ IADETARIHI FROM LG_500_01_CSCARD CSC
LEFT OUTER JOIN LG_500_01_CSTRANS CST ON CST.CSREF=CSC.LOGICALREF
LEFT OUTER JOIN LG_500_01_CSROLL CSR  ON CST.ROLLREF=CSR.LOGICALREF
WHERE CST.TRCODE=9 AND CST.STATNO=1 AND CSC.CURRSTAT=6