lncontperiodpaydet.prinpaid_amt and l.contract_status =1 group by lncontperiodpaydet.loancontract_no )select mbmembmaster.member_no,memb_name,memb_surname,lncontmaster.loancontract_no,principal_balance ,principal_arrear,intyear_arrear,fineyear_arrear,mbmembmaster.membgroup_code,mbucfmembgroup.membgroup_desc from lncontmaster , lncontmaster2 ,mbmembmaster,mbucfmembgroup where lncontmaster2.loancontract_no=lncontmaster.loancontract_no and mbmembmaster.member_no = lncontmaster.member_no and mbucfmembgroup.membgroup_code = mbmembmaster.membgroup_code and lncontmaster.loantype_code between $P{loanstart} and $P{loanend} )]]>