>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.
You might also consider having the information in a single table in the first place.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)