>Hello Experts!
>
>I have three tables. Each of them I am storing date, accountno and balance for diferrent periods,e.g,in the the 1st table for 11th to last date of a month,in the second for 1st to 10th of the same month and in the third table for the previous month.Now I want to find the minimum balance for each account from the 3 tables. Please help me.
The question is a little bit unclear. What do you mean by minimum balance for the account? Do you just store the current balance and date, so the latest date will show the latest current balance?
What exactly are you storing?
If it's not broken, fix it until it is.
My Blog