Never mind. I was trying to make it more complicated then it needed to be. SELECT business_name, SUM(points_awarded) FROM vw_points_awarded WHERE supplier_id = 1001 GROUP BY business_name ORDER BY business_name