Forum Discussion
Getting a row level operation by using two different tables
Hi Folks, I have 2 tables like Loan Party name currency date org_amount john usd 15th jan 30 joy usd 16th jan 40 chandler aud 20th jan 20 monika eur 14th feb 4...
the calculation should be base on the currency = currenct and date = date ?
Hi Daniel29195 ,Date is from 2nd table because the values are varying and we need to chhose a date,depending upon input date it will pick up the values from the 2nd table and multiply the origional amount
tried with solutions but unable to take 2 different columns from 2 different tables
ok.
but if let us say you choose 20 of january,
then all the data of the table Loan, should be multipled by the conversion amount of 20 of jan , respecting the currencies.
is that right ?
Yes Daniel29195 , Thats correct.
