I have Main balance field,balance id in table A and Net balance field ,tx date,balance id in table B
Table A has balance id which table B is referring
every day balance i need to showcase.If the balnce for that a particular day is not available then in TABLE B we dont have any record. But i need to showcase previous days net balance if we have no data for that particular date.And i need to consider all dates
so i have created a date by defining stat date until current date