Query

[kaushal78]

I have one table which is tblredmption which has field like (date,balance,amt,sec_code) and other table tblcashflow where in my cash flow table there is date where i am checking with the tblredemption table and getting the compound interest. If in the redemption table date match with the cash flow table the balance would be calculated else there would be default value
Any one please help me how do i solve my problem.....