multiple SUM from multiple tables to one query

Question

I have 2 tables: incomes & outgo both containing information about transactions. I'd like to run a report to show the overall flow of money based on the totals in the tables, I currently do this manually by using the following queries:

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

as an example, lets say intotal is 500 and outtotal is 300

I'd like a single query that gets both summaries and subtracts the outtotal amount from the intotal amount with a result of 200 in this case. can anyone point me in the right direction or help me with syntax?

SELECT SUM(amount) FROM (SELECT amount FROM incomes UNION SELECT amount FROM outgo) x — Strawberry
– Strawberry, Commented Jul 30, 2015 at 17:33

6be709c0 · Accepted Answer · 2015-07-30 17:33:21Z

1

Try

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

And use with a.intotal and b.outtotal

Or directly with

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

edited Jul 30, 2015 at 17:33

answered Jul 30, 2015 at 17:27

6be709c0

8,5014 gold badges40 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kenney · Accepted Answer · 2015-07-30 17:20:55Z

1

How about this:

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

answered Jul 30, 2015 at 17:20

Kenney

9,11317 silver badges21 bronze badges

Collectives™ on Stack Overflow

multiple SUM from multiple tables to one query

2 Answers 2

Try

Or directly with

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Try

Or directly with

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related