Forum Discussion

sahubibhuti45's avatar
sahubibhuti45
Icon for Helper I rankHelper I
2 years ago

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...
Need Help
sahubibhuti45's avatar
sahubibhuti45
Icon for Helper I rankHelper I
2 years ago

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

sahubibhuti45's avatar
sahubibhuti45
Icon for Helper I rankHelper I
2 years ago

tried with solutions but unable to take 2 different columns from 2 different tables