从多个表到一个查询的多个SUM - multiple SUM from multiple tables to one query

multiple SUM from multiple tables to one query

本文关键字：一个查询 SUM | 更新日期: 2023-09-27

我有2个表:incomes &outgo都包含有关事务的信息。我想运行一个报告，以显示基于表中的总数的总体资金流动，我目前通过使用以下查询手动完成此操作:

1) SELECT amount, SUM(amount) AS intotal FROM incomes
2) SELECT amount, SUM(amount) AS outtotal FROM outgo

以

为例，设intotal为500, outtotal为300

我想要一个单一的查询，获得两个摘要，并从intotal金额减去outtotal金额，在这种情况下200的结果。谁能给我指出正确的方向或帮助我语法?

Try

SELECT
    (SELECT amount, SUM(amount) AS intotal FROM incomes) AS a,
    (SELECT amount, SUM(id) AS outtotal FROM outgo) AS b

与a.intotal和b.outtotal一起使用

SELECT 
    ((SELECT SUM(amount)FROM incomes) - (SELECT SUM(amount)FROM outgo)) AS total

这个怎么样:

SELECT
   (SELECT SUM(amount) FROM incomes)
   -
   (SELECT SUM(amount) FROM outgo)