MYSQL summing values of multiple tables

Question

I have multiple tables, I can list their rows to my website.

What I want is where last column has same value, I want to add up rows values and list as one line.

What I have:

Hioss
AUR
Top
1
1
0
Shen

Hioss
AUR
Top
1
1
0
Shen

Kanani
AUR
Jungle
1
1
0
Reksai

I don't want to get data like this. If last column has same values (Shen) I want to sum int values and show as one line at my website.

What I want to do:

Hioss
AUR
Top
2
2
0
Shen

Kanani
AUR
Jungle
1
1
0
Reksai

My mysql query:

mysql_query("SELECT * FROM table1 UNION SELECT * FROM table2");

How can I do it? What should I do?

You can wrap your UNION query in an outer query that groups/sums them, ie. SELECT col1, col2, col3, SUM(col4), SUM(col5), col6 FROM (SELECT * FROM table1 UNION SELECT * FROM table2) a GROUP BY col6 (note the col1-col6 are just examples, as you don't give explicit column names) — Sean
– Sean, Commented Feb 14, 2016 at 22:22
@Sean col1 col2 col3s are working but sum(colx) are not working ints are listing as 0 0 0 0 others are normal — Yusuf Devranlı
– Yusuf Devranlı, Commented Feb 14, 2016 at 23:09

Bernd Buffen · Accepted Answer · 2016-02-14 22:23:00Z

1

Try this. i dont know the fieldnames. You must change it

SELECT fieldnam1,fieldnam2, sum(fieldnam3),fieldnam4
FROM (
    SELECT * FROM table1 
    UNION 
    SELECT * FROM table2
) as result
GROUP by fieldnam4;

answered Feb 14, 2016 at 22:23

Bernd Buffen

15.1k2 gold badges27 silver badges41 bronze badges

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

4 Comments

Yusuf Devranlı Over a year ago

mysql_query("SELECT player,takim, sum(oynananoyun),sum(win),sum(lose),sum(kill),sum(death),sum(assist),sum(cs),sum(gold),sum(goldshare),sum(gpm),sum(egpm),sum(fb),sum(dmg),sum(dmgshare),sum(dpm),sum(wardplaced),sum(wardcleared),sum(wardplacedpm),sum(wardclearedpm),sum(wardplacedshare),sum(wardclearedshare),sum(cspm),sum(dakika),sum(saniye),sum(kp),sum(deathpercentage) FROM ( SELECT * tclhafta1mac1 UNION SELECT * FROM tclhafta1mac2 ) as result GROUP by champion "); it gives: right syntax to use near 'tclhafta1mac1 UNION SELECT * FROM tclhafta1mac2 ) as result GROUP by champion' at line 2

Yusuf Devranlı Over a year ago

i was missing "from" i added it but it still doesnt work doesnt give errors but all values are 0 0 0 0 0

Yusuf Devranlı Over a year ago

fieldnam1,fieldnam2 working but sum(fieldname3) not working. ints are not working texts are worknig :/

Yusuf Devranlı Over a year ago

i added "as x"s after "sum(x)"s and it worked thanks!

Collectives™ on Stack Overflow

MYSQL summing values of multiple tables

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related