# Summarizing data with outer joins?

**URL:** <https://forum.codewithmosh.com/t/summarizing-data-with-outer-joins/7196>\
**Category:** SQL\
**Created:** [September 6, 2021, 3:55pm UTC](https://forum.codewithmosh.com/t/summarizing-data-with-outer-joins/7196 "2021-09-06T15:55:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![arthurlorente](https://avatars.discourse-cdn.com/v4/letter/a/bc79bd/32.png) [@arthurlorente](https://forum.codewithmosh.com/u/arthurlorente)\
**Post date:** [September 6, 2021, 3:55pm UTC](https://forum.codewithmosh.com/t/summarizing-data-with-outer-joins/7196/1 "2021-09-06T15:55:55Z")

</div>

Hey folks! I have just finished the outer joins exercise that we get on the very first time that we see it on the course. My solution looked the exact same as Mosh’s:

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

However, I noticed that in the real world I might also have wanted to check the total amount that each product sold. I know that I could easily do that if I just referred to the products table itself, but what if I wanted to maintain the outer join structure? Could I eliminate the duplicate entries and just have a single row with the full quantity for each product? I know it doesn’t make sense contextually, I am really just interested in the syntax and knowing whether or not I could do it.

Thanks in advance!

---

<div class="post-metadata">

**Author:** ![SAM](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.codewithmosh.com/sam/32/167_2.png) [@SAM](https://forum.codewithmosh.com/u/SAM)\
**Post date:** [September 7, 2021, 4:32am UTC](https://forum.codewithmosh.com/t/summarizing-data-with-outer-joins/7196/2 "2021-09-07T04:32:55Z")

</div>

That’s covered in section 5 “Summarizing Data”.