如何在MySQL中对多个表中的列求和? [英] How can I sum columns across multiple tables in MySQL?

问题描述

在MySQL中，我有两个表:

In MySQL I have two tables:

Table MC:
----------------
|TransNo | Qty |
|--------|-----|
|  xxx1  |  4  | 
|  xxx3  |  3  |

和

Table Amex:
----------------
|TransNo  | Qty |
|---------|-----|
|  xxx1   |  2  |
|  xxx5   |  1  | 

我需要对表MC(等式7)和表Amex(等式3)中的Qty列求和，并将结果作为总数量.

I need to sum the Qty column from table MC (eq. 7) and table Amex (eq. 3) and have result as Total Qty.

当我这样做

SELECT (SUM(amex.Qty) + SUM(mc.Qty)) as total_qty from amex, mc

我得到笛卡尔乘积(20)，但我需要的正确答案是10.如何更改此查询以获得正确的结果?

I get the cartesian product (20), but the correct answer I need is 10. How do I need to change this query to get the correct result?

推荐答案

SELECT SUM(t.Qty) AS total_qty
    FROM (SELECT Qty FROM MC
          UNION ALL
          SELECT Qty FROM Amex) t

这篇关于如何在MySQL中对多个表中的列求和?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！