在PHP中创建所有表行字段的总和

Question

I have 4 tables, in this all tables have 3 rows[record] and 3 column[field] field like Date Name Total. This table like below:

First Table

   Date                  Name                      Total
 2012-11-07             Manoj                       10
 2012-11-08             Ganesh                       4
 2012-11-09             Sri                         30

Second Table

  Date                   Name                      Total
2012-11-07               Raju                         5
2012-11-08               ggg                          3
2012-11-09               Shshi                       30

Third Table

 Date                   Name                      Total
2012-11-07              Ram                         2
2012-11-08               gm                         5
2012-11-09             Shsse                       30

I need Output Like following type in PHP

Date          Total
2012-11-07      17
2012-11-08      12
2012-11-09      90

It should display all total in between date in PHP

Answer 1

SELECT DATE, SUM(Total) totalSum
FROM
(
    SELECT * FROM tableA
    UNION ALL
    SELECT * FROM TableB
    UNION ALL 
    SELECT * FROM tableC
) s
GROUP BY DATE

• SQLFiddle Demo