Sum the column of the table

Question

I have 2 tables below:

Table1
+-----------+------------+-----------+-----------+
| date      | TRAFFIC1   | PAYLOAD11 | PAYLOAD12 |
+-----------+------------+-----------+-----------+
|2015-01-01 | 2          | 2         | 2         |
|2015-01-01 | 3          | 3         | 3         |
|2015-01-02 | 2          | 2         | 2         |
|2015-01-02 | 3          | 3         | 3         |
+-----------+------------+-----------+-----------+

Table2
+-----------+------------+-----------+-----------+
| date      | TRAFFIC21  | PAYLOAD21 | PAYLOAD22 |
+-----------+------------+-----------+-----------+
|2015-01-01 | 2          | 2         | 2         |
|2015-01-01 | 3          | 3         | 3         |
|2015-01-02 | 2          | 2         | 2         |
|2015-01-02 | 3          | 3         | 3         |
+-----------+------------+-----------+-----------+

I want to sum payload from 2 tables above group by date?

Put your tables structure – Gul Muhammad Akbari Jan 13 '15 at 08:31 — Gul Muhammad Akbari, Jan 13 '15 at 08:31

score 0 · Answer 1 · edited May 23 '17 at 11:57

0

Try like this:

SELECT SUM(t1.payload)+SUM(t2.payload) AS total FROM table1 AS t1,table2 AS t2 GROUP BY date

for more check this: Query SUM for two fields in two different tables

edited May 23 '17 at 11:57

Community

1
1

answered Jan 13 '15 at 08:36

Gul Muhammad Akbari

260
3
13

But you have to join some fields between your tables – Gul Muhammad Akbari Jan 13 '15 at 08:49

score 0 · Accepted Answer · answered Jan 13 '15 at 08:52

0

SELECT date, SUM(payload) FROM (
SELECT date, `PAYLOAD11` + `PAYLOAD12` as payload FROM Table1
union all
SELECT date, `PAYLOAD21` + `PAYLOAD22` as payload FROM Table2) grp
GROUP BY date

SQLFIDDLE

answered Jan 13 '15 at 08:52

Praveen Prasannan

7,093
10
50
70

Sum the column of the table

2 Answers2