Re: [Mifos-users] Want A Sql Statement

2011-03-28 Thread Ryan Whitney
n_id=9 >> >> and rev.account_id=account_trxn.account_id >> >> ) >> >> >> >> >> >> Thanks, >> >> Ramya >> >> >> >> >> >> >> >> >> From: Trilok J. Pandya

Re: [Mifos-users] Want A Sql Statement

2011-03-27 Thread Ramya.Toshniwal
=client.customer_id where account_trxn.account_action_id=1 and account_trxn.action_datemailto:trilok.pan...@lightmicrofinance.com] Sent: Monday, March 28, 2011 11:38 AM To: Mifos Developer Discussions; mifos-users@lists.sourceforge.net Subject: [Mifos-users] Want A Sql Statement Dear friends, i want

[Mifos-users] Want A Sql Statement

2011-03-27 Thread Trilok J. Pandya
Dear friends, i want a sql statement in which,  there is display of all loan prepayment. it means i want list of loans which is fully repayment before loan last installment date. -- --