mysql - 使用分组依据显示多个表中的相同字段

Question

Table 1
id_mkt - varchar,
point - varchar

Table 2
id_mkt - varchar,
point - varchar

这是我的代码:

//表1

SELECT * FROM data1 GROUP by id_mkt asc limit 10

//表2

SELECT * FROM data2 GROUP by id_mkt asc limit 10

result table 1: 
id_mkt   | point  
  1      | 100   
  2      | 200 
  4      | 300   

result table 2: 
id_mkt   | point 
  3      | 300   
  2      | 400 
  1      | 100  

我想要这样的结果:

id_mkt   | point 
  1      | 200 
  2      | 600
  3      | 300  
  4      | 300 

感谢帮助

Answer 1

SELECT t.id_mkt, SUM(t.point) AS total FROM
(
  (SELECT * FROM table2)
  UNION
  (SELECT * FROM table1)
) AS t 
GROUP BY id_mkt;