SQL Sorgu Proje Kodlu Cari Hareketler

SELECT CASE C.TRCODE WHEN 20 THEN 'GELEN HAVALE' WHEN 5 THEN 'VIRMAN' WHEN 38 THEN 'SATIS FATURASI'
WHEN 31 THEN 'ALIS FATURASI' WHEN 34 THEN 'ALINAN HIZMET FATURASI' ELSE 'DIGER' END AS ISLEMTURU,
(SELECT CODE FROM LG_042_CLCARD WHERE LOGICALREF=C.CLIENTREF)CARIKODU,
(SELECT DEFINITION_ FROM LG_042_CLCARD WHERE LOGICALREF=C.CLIENTREF)CARIADI,
CASE C.MODULENR
    WHEN 4 THEN
    (SELECT PROJECTREF FROM LG_042_01_INVOICE WHERE LOGICALREF=C.SOURCEFREF)
    WHEN 7 THEN
    (SELECT PROJECTREF FROM LG_042_01_BNFLINE WHERE LOGICALREF=C.SOURCEFREF)
    WHEN 5 THEN
    (SELECT PROJECTREF FROM LG_042_01_CLFICHE WHERE LOGICALREF=C.SOURCEFREF)
END PROJEKODU,C.SIGN B_A,C.LINEEXP SATIRACIKLAMA,C.AMOUNT TUTAR,
CONVERT(DATE,C.DATE_)TARIH,C.MONTH_ AY,C.YEAR_ YIL,
(SELECT VADEGUN FROM LG_XT020 WHERE CARLOGREF=C.CLIENTREF)VADEGUN,
(SELECT SUM(YUZDE) FROM LG_XT030 WHERE CARLOGREF=C.CLIENTREF)KES_YUZDE_TOPLAM,
CASE WHEN C.MODULENR=4 AND C.SIGN=1 THEN -(C.AMOUNT*3/100)
     WHEN C.MODULENR=4 AND C.SIGN=0 THEN +(C.AMOUNT*3/100) ELSE 0 END AS STOPAJ    
FROM LG_042_01_CLFLINE C WHERE C.CLIENTREF=2400 AND C.CANCELLED=0