Re: mysql sums not working correctly with joins

[Aimee Molleken]

The answer that my teacher marked as correct is this:
(SELECT

sales_people.person_id,

sales_people.last_name,

sales_people.first_name,

sales_region.Region_id,

TRIM(sales_region.`name`) AS 'Region Name',

year,
month,
amount_sold


FROM sales

RIGHT OUTER JOIN sales_people_region

ON sales.region_id = sales_people_region.region_id

RIGHT OUTER JOIN sales_region

ON sales_people_region.region_id = sales_region.region_id

RIGHT OUTER JOIN sales_people

ON sales_people_region.person_id = sales_people.person_id

ORDER BY sales_people.person_id, sales_region.region_id ASC, month ASC,amount_sold);