Hi All,

I have a situation where I need to get data from more than one table, but where the 
fields in the table are identical, the two tables are holding data for different 
years. The queries I would like to execute would be something along the lines of this: 
-

SELECT SUM(T1.F1) AS C1, SUM(T2.F1) AS C2 FROM T1, T2

Which I would like to give the total of T1.F1 in C1 and the total of T2.F1 in C2.

What I get however is the sum of T1.F1 * sum of T2.F1 in both result fields and the 
number of records found as being the sum of the number of records in T1 * those in T2.

What I would like to do eventually with this is get the sum of F1 from any number of 
tables each representing a year as I don't want to lump all my data into one big table 
that will get out of hand.

Can anyone tell me the right way to go about this?

Cheers

Dan

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to