'LRT' and loantype_code between $P{as_startlntype} and $P{as_endlntype} ) GROUP BY SLSLIPPAYINDET.SHRLONTYPE_CODE, LNLOANTYPE.PREFIX, LNLOANTYPE.LOANTYPE_DESC, CMCOOPMASTER.COOP_NAME UNION SELECT SLSLIPPAYINDET.SHRLONTYPE_CODE, LNLOANTYPE.PREFIX, LNLOANTYPE.LOANTYPE_DESC, 0 AS SUM_PRNAMT, 0 AS SUM_INTAMT, 0 AS SUM_INTARRAMT, 0 AS SUM_ITEMAMT ,0 AS PAYOUT, 0 AS SUM_FINEYEAR_ARREAR, 0 AS SUM_FINE_ARREAR, 0 AS SUM_FINE_PERIOD, CMCOOPMASTER.COOP_NAME , IFNULL( SUM(SLSLIPPAYINDET.INTEREST_PAYAMT), 0 ) AS SUM_INT_RETURN, IFNULL( SUM(SLSLIPPAYINDET.FINE_PERIOD), 0 ) AS SUM_FINE_RETURN FROM SLSLIPPAYIN, SLSLIPPAYINDET, LNLOANTYPE, SLUCFSLIPTYPE ,CMCOOPMASTER WHERE ( SLSLIPPAYIN.PAYINSLIP_NO = SLSLIPPAYINDET.PAYINSLIP_NO ) AND ( SLSLIPPAYIN.COOP_ID = CMCOOPMASTER.COOP_ID ) AND ( SLSLIPPAYINDET.SHRLONTYPE_CODE = LNLOANTYPE.LOANTYPE_CODE ) AND ( SLSLIPPAYIN.SLIPTYPE_CODE = SLUCFSLIPTYPE.SLIPTYPE_CODE ) AND (( SLSLIPPAYIN.SLIP_DATE between $P{adtm_startdate} and $P{adtm_enddate} ) And ( SLSLIPPAYIN.SLIP_STATUS = 1 ) and SLSLIPPAYINDET.SLIPITEMTYPE_CODE ='LON' and MONEYTYPE_CODE between $P{cashtype} and $P{end_cashtype} and ( SLSLIPPAYIN.SLIP_STATUS = 1 ) and SLSLIPPAYIN.SLIPTYPE_CODE = 'LRT' and loantype_code between $P{as_startlntype} and $P{as_endlntype}) GROUP BY SLSLIPPAYINDET.SHRLONTYPE_CODE, LNLOANTYPE.PREFIX, LNLOANTYPE.LOANTYPE_DESC, CMCOOPMASTER.COOP_NAME ) a group by SHRLONTYPE_CODE, PREFIX, LOANTYPE_DESC, COOP_NAME]]>