MySQL统计不同表的数据

Question

表A

Status
1
1
1
2
2
3

表B

Status
1
1
2
2
2
2
3
3

如何得到如下结果表

结果表

Status    Count
1           5
2           6
3           3

帮助我构建 SQL 查询以获取结果表中的计数。

Answer 1

Try this

SELECT Status, COUNT(*) FROM
(SELECT a.Status FROM TableA AS a
UNION ALL
SELECT b.Status FROM TableB AS b) UN
GROUP BY Status