Hi Sampath, I have got it, Thanks, It solved my issue as below, hope am correct
*select l.account_no as loanAccount, sa.account_no as linkedAccount, sa.account_no as surplusAccount from m_loan lleft join m_portfolio_account_associations mp on mp.loan_account_id = l.id <http://l.id> left join m_savings_account sa on sa.id <http://sa.id> = mp.linked_savings_account_id* *where l.account_no=${accountNo}* Thanks Regards On Fri, May 12, 2017 at 2:25 PM, Sampath Kumar G < [email protected]> wrote: > Hi Ippez, > > In m_portfolio_account_associations table, you will get those details. > > > > Regards, > Sampath > > > > *Conflux Technologies Pvt Ltd <http://www.confluxtechnologies.com/> *#304, > 2nd Floor, 7th Main Road > > HRBR Layout 1st Block > > Bengaluru, Karnataka, 560043 INDIA > > > Disclaimer: The information contained in this e-mail message and any > files/attachment transmitted with it is confidential and for the sole use > of the intended recipient(s) or entity identified. If you are not the > intended recipient, please email: [email protected] and > destroy/delete all copies and attachment thereto along with the original > message. Any unauthorised review, use, disclosure, dissemination, > forwarding, printing or copying of this email or any action taken in > reliance on this e-mail is strictly prohibited and is unlawful. The > recipient acknowledges that Conflux Technologies Private Limited or its > subsidiaries and associated companies are unable to exercise control or > ensure or guarantee the integrity of/over the contents of the information > contained in e-mail transmissions. Before opening any attachments, please > check. > > > On Fri, May 12, 2017 at 3:29 PM, Ippez Robert <[email protected]> > wrote: > > > Which table and column do i get the savings account linked to a loan > during > > loan creation when Create Standing Instruction at Disbursement is > checked? > > > > Am designing a report and i need this field (linked account) > > -- > > Ippez Roberts > > > > Tel: +256788725408 <+256%20788%20725408>/789643284 > > Skype ID: ippez.robert1 > > Email: [email protected] > > > -- Ippez Roberts Director & Founder - Skyline Technologies Uganda "IT Consultants & Engineers" P.O.Box 155, Moyo UGANDA. Tel: +256788725408/789643284 Skype ID: ippez.robert1 Email: [email protected]
