php - 我想从 5 个表中求和，这些表的一列名为 "UP"

Question

我有 5 个表(bepd、tirpd、elpd、frpd、kopd)，它们的同一列名为“Up”，我想从所有表中求出 Up 的总和，并在 php 代码中显示它。谁能帮帮我？

Answer 1

select  sum(SumUp)
from    (
        select  sum(up) as SumUp
        from    Table1 
        union all
        select  sum(up)
        from    Table2
        union all
        select  sum(up)
        from    Table3
        union all
        ...
        ) SubQueryAlias