can we create 12 sql for a report(i.e Jan - Dec). The queries also need to have user input that determine the range of date and runcontrol_id. I want the formula and the running total fields to check each table seperately.

I agree with Sastry, that you can do it.

My question is why? You could retrieve all the data in one command and then pivot the data using a crosstabs.

Or you could define the column names in such a way that the can reorder the data or use the data however you want. I am assuming of course that what you are querying is the same from one month to the next.

Or you could take the really big step and use a stored procedure and do whatever you want with the data, far and away more flexible than joining the tables together.

Just some thoughts