return sum of a specific column from all table - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

return sum of a specific column from all table

isacisac Posts: 4Member
Please help me with this

I want to list all tables in ms access database and total of a specific column (I have a column name "total" in all tables).I found sql statement that returns list of table names but how do I get a column sum from all tables and place next to corespoding table?

I have tried so far

[code]
select table_name from information _schema.columns where column_name=
Sign In or Register to comment.