How to Add Data From Different Tables

[vvicin01]

I have three tables in a database that I would like to
add the totals of each column. The database is used to store hockey players goals and assist and other fields. I want to add the totals of each player from the three tables.
I know you can add the sum of a column, but what about a particular row.

Thanks

 

[Sawatzky]

dear vvicin01

you could do it like this

Select sum(field1) + sum (field2) as total from sourcetable.

regards Astrid

 

[Guest_imported]

This does not seem to work when the data is in different tables.

 

[rayna]

Perhaps then, you could use a query to pull all of the columns into one table (or one result set) and then do a second query from that one, doing as Astrid suggested (adding the fields together).

Rayna

 

[Sawatzky]

Dear vvicin,

sorry for not reading exactly your question,

If your tables are alike, which means all the fields you need in the tables are of the same structure of fields and datatypes, you could try to use a Union statement.

Select sum(field1) + sum (field2) as total from sourcetable1
Union
Select sum(field1) + sum (field2) as total from sourcetable2.

whihc you can requery on the fly:

SELECT Sum(total) AS jane
FROM [SELECT sum(field1) + sum (field2) as total from sourcetable1
union
SELECT sum(field1) + sum (field2) as total from sourcetable2 ]. AS [bob];


regards Astrid