sql subtract subquery sum multiple tables

Total Post:29

Points:203
 2875  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. 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



      Modified On Mar-31-2018 03:59:12 AM

Answer

NEWSLETTER

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