sql sum of sums of two tables

Question

how to get a sum of two sums from two tables?

SELECT (SELECT SUM(col) FROM table1) + SELECT (SUM(col) from table2)

doesn't work

score 0 · Answer 1 · answered Oct 29 '17 at 12:32

0

You are very close. You just need parens around each subquery:

SELECT (SELECT SUM(col) FROM table1) + (SELECT SUM(col) from table2)

If either subquery could return NULL, you might prefer:

SELECT COALESCE(t1.s, 0) + COALESCE(t2.s)
FROM (SELECT SUM(col) as s FROM table1) t1 CROSS JOIN
     (SELECT SUM(col) as s from table2) t2;

answered Oct 29 '17 at 12:32

Gordon Linoff

@Greens . . . I don't think you will get a syntax error on either of these. In your query, I do explain it: "You just need parens around each subquery". – Gordon Linoff Oct 29 '17 at 20:48

score 0 · Answer 2 · edited Jun 20 '20 at 09:12

0

Due to this link, you can do that by :

SELECT T1C1 , T2C1
FROM
 ( select SUM(Col1) T1C1 FROM  T1 ) A
CROSS JOIN 
 ( select SUM(Col1) T2C1 FROM  T2 ) B

also you can visit these links:

edited Jun 20 '20 at 09:12

Community

answered Oct 29 '17 at 12:35

1

@Greens - Because in second `select` you have placed the parenthesis in wrong place. `..+ SELECT (SUM(col)..` **-->** `..+ (SELECT SUM(col)..` – Pரதீப் Oct 29 '17 at 12:57

score 0 · Answer 3 · edited Oct 29 '17 at 12:55

0

select coalesce(sum(x),0) from
 (
    Select sum(a) x from tab1
    Union all
    Select sum(b) from tab2
 ) Ilv

edited Oct 29 '17 at 12:55

Pரதீப்

answered Oct 29 '17 at 12:48

Ab Bennett

3 Answers3