Please help me with this
I want to list all tables in sql server compact 3.5 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
select table_name from information _schema.columns where column_name=”total”
any bit of info would be helpful