# Sum () after a join

**URL:** <https://forum.codewithmosh.com/t/sum-after-a-join/7956>\
**Category:** SQL\
**Created:** [October 15, 2021, 9:49pm UTC](https://forum.codewithmosh.com/t/sum-after-a-join/7956 "2021-10-15T21:49:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![supertantan](https://avatars.discourse-cdn.com/v4/letter/s/dc4da7/32.png) [@supertantan](https://forum.codewithmosh.com/u/supertantan)\
**Post date:** [October 15, 2021, 9:49pm UTC](https://forum.codewithmosh.com/t/sum-after-a-join/7956/1 "2021-10-15T21:49:07Z")

</div>

I want to know how it is possible to do a sum of all the quantity after this join. If you have any idea i’ll take it 🙂

 ![image](https://us1.discourse-cdn.com/flex020/uploads/codewithmosh/original/2X/3/31e0bb61fdf3dd4dff343016f98a4886b56a5b14.png)

---

<div class="post-metadata">

**Author:** ![alex.cisija](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.codewithmosh.com/alex.cisija/32/298_2.png) [@alex.cisija](https://forum.codewithmosh.com/u/alex.cisija)\
**Post date:** [October 15, 2021, 10:21pm UTC](https://forum.codewithmosh.com/t/sum-after-a-join/7956/2 "2021-10-15T22:21:40Z")

</div>

You should be able to add it as another column after `SELECT`:

![image](https://us1.discourse-cdn.com/flex020/uploads/codewithmosh/original/2X/d/d79bdb3a437c0a0963f59e86140bf16cb1dbc57f.png)

You can also name that “Sum” column if you want:  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/codewithmosh/original/2X/a/a4bcd9b48b945b8ef26b399604b02039efc56662.png)

Does that answer your question? 🙂

---

<div class="post-metadata">

**Author:** ![supertantan](https://avatars.discourse-cdn.com/v4/letter/s/dc4da7/32.png) [@supertantan](https://forum.codewithmosh.com/u/supertantan)\
**Post date:** [October 16, 2021, 5:50pm UTC](https://forum.codewithmosh.com/t/sum-after-a-join/7956/3 "2021-10-16T17:50:34Z")

</div>

Yes absolutely, thank your very much !!!