SQL SUBTRACT SUBQUERY SUM MULTIPLE TABLES

Andrew Deniel

Total Post:29

Points:203
Posted by  Andrew Deniel
 2608  View(s)
Ratings:
Rate this:

How can I subtract the sum of a subquery table from another table?

SELECT i.column1 * i.column2 AS Expr1
    , i.column1 * i.column2 - (SELECT SUM(table2.column1) AS Expr1 
                               FROM table2 
                               WHERE (table2.column3 = table1.column3)) AS derivedExpression
FROM table1

Only the derivedExpression in the first row is correct. The rest rows returns null for derivedExpression. For Expr1, everything is fine. Any help?

  1. Ida B Wells

    Post:30

    Points:210
    Re: sql subtract subquery sum multiple tables


    SELECT
    i.column1 * i.column2 AS Expr1
        , i.column1 * i.column2 - (SELECT COALESCE(SUM(table2.column1), 0) AS Expr1 
                                   FROM table2 
                                   WHERE (table2.column3 = table1.column3)) AS derivedExpression
    FROM table1

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!