Şu şekil de denedim , sonuç 0 rows Affected.
SELECT
PLN.DATE_ AS 'Vade_TARİHİ',
PLN.PROCDATE AS 'İşlem_TARİHİ',
PLN.PAYNO AS 'Ö.D.P.SATIR NO',
CL.TRANNO AS 'Fiş_No',
BANK.CODE AS BANKA_KODU,
BANK.DEFINITION_ AS BANKA,
HESAP.CODE AS HESAP_KODU,
HESAP.DEFINITION_ AS HESAP_AÇIKLAMASI,
CC.CODE AS Öğrenci_No,
CC.DEFINITION_ AS ÜNVANI,
PLN.TOTAL AS 'HS.Düşmesi_Gereken',
CL.AMOUNT AS 'POS_dan_Çekilen'
FROM LG_011_01_PAYTRANS AS PLN JOIN LG_011_BANKACC AS HESAP ON HESAP.LOGICALREF=PLN.BANKACCREF JOIN
LG_011_BNCARD AS BANK ON BANK.LOGICALREF = HESAP.BANKREF JOIN LG_011_CLCARD AS CC ON CC.LOGICALREF=PLN.CARDREF LEFT OUTER JOIN
LG_011_01_CLFLINE AS CL ON CL.LOGICALREF=PLN.FICHEREF
Where PLN.TRCODE=70 AND PLN.DATE_ BETWEEN {FLTDATEBEG(1)} AND {FLTDATEEND(1)}
Şu şekil de de sonuç aynı ,
SELECT
PLN.DATE_ AS 'Vade_TARİHİ',
PLN.PROCDATE AS 'İşlem_TARİHİ',
PLN.PAYNO AS 'Ö.D.P.SATIR NO',
CL.TRANNO AS 'Fiş_No',
BANK.CODE AS BANKA_KODU,
BANK.DEFINITION_ AS BANKA,
HESAP.CODE AS HESAP_KODU,
HESAP.DEFINITION_ AS HESAP_AÇIKLAMASI,
CC.CODE AS Öğrenci_No,
CC.DEFINITION_ AS ÜNVANI,
PLN.TOTAL AS 'HS.Düşmesi_Gereken',
CL.AMOUNT AS 'POS_dan_Çekilen'
FROM LG_011_01_PAYTRANS AS PLN JOIN LG_011_BANKACC AS HESAP ON HESAP.LOGICALREF=PLN.BANKACCREF JOIN
LG_011_BNCARD AS BANK ON BANK.LOGICALREF = HESAP.BANKREF JOIN LG_011_CLCARD AS CC ON CC.LOGICALREF=PLN.CARDREF LEFT OUTER JOIN
LG_011_01_CLFLINE AS CL ON CL.LOGICALREF=PLN.FICHEREF
Where PLN.TRCODE=70 AND PLN.DATE_ BETWEEN {FLTDATEBEG(2)} AND {FLTDATEEND(2)}