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?
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php