Sum more columns

Muiter · #1 (**permalink**) 10-23-11, 10:07

I have an query with 2 different SUM's. How can I calculate the total of all 3 in the query?

Code:

SELECT
SUM(inh_pr.prijs_verkoop) AS prijs_verkoop1,
SUM(IF(inh_plt.overrule > 0, inh_plt.overrule, inh_plt.verkoop_stk)) AS prijs_verkoop2,
SUM(inh_lntk.totaal_stk) AS prijs_verkoop3
FROM 3_product_folder AS fld
LEFT JOIN 0_calculatie_inh_id_geg_product AS inh_pr
ON inh_pr.calculatie_inh_id = fld.product_id
LEFT JOIN 0_calculatie_inh_id_geg_plaat AS inh_plt
ON inh_plt.calculatie_inh_id = fld.product_id
LEFT JOIN 0_calculatie_inh_id_geg_lntk_product AS inh_lntk
ON inh_lntk.calculatie_inh_id = fld.product_id
LEFT JOIN 2_folder AS fld2
ON fld2.id = fld.folder_id

ankur02018 · #2 (**permalink**) 10-24-11, 02:35

Quote:

Originally Posted by Muiter

I have an query with 2 different SUM's. How can I calculate the total of all 3 in the query?

Code:

SELECT
SUM(inh_pr.prijs_verkoop) AS prijs_verkoop1,
SUM(IF(inh_plt.overrule > 0, inh_plt.overrule, inh_plt.verkoop_stk)) AS prijs_verkoop2,
SUM(inh_lntk.totaal_stk) AS prijs_verkoop3
FROM 3_product_folder AS fld
LEFT JOIN 0_calculatie_inh_id_geg_product AS inh_pr
ON inh_pr.calculatie_inh_id = fld.product_id
LEFT JOIN 0_calculatie_inh_id_geg_plaat AS inh_plt
ON inh_plt.calculatie_inh_id = fld.product_id
LEFT JOIN 0_calculatie_inh_id_geg_lntk_product AS inh_lntk
ON inh_lntk.calculatie_inh_id = fld.product_id
LEFT JOIN 2_folder AS fld2
ON fld2.id = fld.folder_id

Try This

Code:

SELECT (prijs_verkoop1 + prijs_verkoop2 + prijs_verkoop3) as Total from (above query) as a;

r937 · #3 (**permalink**) 10-24-11, 05:49

muiter, your query doesn't work because it's missing the GROUP BY clause

Muiter · #4 (**permalink**) 10-24-11, 14:57

Quote:

Originally Posted by ankur02018

Try This

Code:

SELECT (prijs_verkoop1 + prijs_verkoop2 + prijs_verkoop3) as Total from (above query) as a;

I have tried that but I can't get it to work in my query.

Quote:

Originally Posted by r937

muiter, your query doesn't work because it's missing the GROUP BY clause

It does work but to be complete I should probably use the GROUP BY clause. Should I add one ore more columns to the GROUP BY clause?

The question is how to calculate the total.

r937 · #5 (**permalink**) 10-24-11, 15:08

Quote:

Originally Posted by Muiter

It does work but to be complete I should probably use the GROUP BY clause. Should I add one ore more columns to the GROUP BY clause?

wait a moment, i have to apologize, i was too hasty, and after looking at your query more closely, it does not need a GROUP BY clause

ankur's solution is correct

Internet Services

Web Development

Digital Marketing

Consumer Tech