mysql - 从具有相同结构的表中添加两列

Question

我有两个表如下:-

           Table 1                      Table 2 
         date     value             date     value 
         1120101   v11              1120102   v21
         1120202   v12              1120303   v22  
         1120203   v13              1120104   v23  

得到以下输出的sql查询是什么

        date         value 
       1120101       (v11)
       1120102       (v12+v21)
       1120103       (v13+v22)
       1120104       ( v23)  

我厌倦了查询但未能获得所需的输出

select table1.date,
       table2.date,
       table1.delta+table2.delta as delta 
from table1,
     table2   
where table1.date=table2.date;

提前致谢。

Answer 1

SELECT date, SUM(value)
FROM
(
    SELECT date, value FROM table1
    UNION ALL
    SELECT date, value FROM table2
) a
GROUP BY date

• SQLFiddle Demo (data is different but idea is the same)