How Sum values in dynamic table column.

See more:

SQL

can someone help me with this
I have an Access Database on which I have tables with similar structure and columns name column ‘a’ and column ‘b’. I can use the below query to get this output.
Table | result

-------|--------

SELECT "Table1" AS Table, SUM(a) - SUM(b) AS Result FROM table1                                                           UNION                                                                                                                                                         SELECT "Table2" AS Table, SUM(a) - SUM(b) AS Result FROM table2                                             UNION                                                                                                                                                         SELECT "Table3" AS Table, SUM(a) - SUM(b) AS Result FROM table3 

I would like to know is there any way to write a query without hard coding the table names in query? I have posted c# section of the forum under same title.
www.codeproject.com/.../How-Sum-values-in-dynamic-table-column[^]