Member Avatar

please help for query...

i want sum (kns+kng) by name - example

the result should be:

name|sum

john - 36
bart - 16
steve - 53
jim - 10

tnx

  • 2 Contributors
  • forum 2 Replies
  • 213 Views
  • 5 Hours Discussion Span
  • comment Latest Post Latest Post by Paor

Recommended Answers

Answered by diafol 3,720 in a post from

There may be an easier way, but I think this works:

SELECT `name`, SUM(sm) AS total FROM ((SELECT `name`, kns AS sm FROM tab1) UNION ALL (SELECT `name`, kng AS sm FROM tab2)) AS tbl GROUP BY tbl.name

You may benefit from using an user_id in …

Jump to Post

All 2 Replies

Member Avatar

There may be an easier way, but I think this works:

SELECT `name`, SUM(sm) AS total FROM ((SELECT `name`, kns AS sm FROM tab1) UNION ALL (SELECT `name`, kng AS sm FROM tab2)) AS tbl GROUP BY tbl.name

You may benefit from using an user_id in order to relate your tables properly.

Member Avatar

@diafol
thank you very much, i really appreciate your answer

This is a very simplified example, i just want to learn how to do that

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.

Sign Up — It's Free!