Sorry! Couldn't execute SELECT category_wide_zoom_lens.sku, SUM(inventory.rent_count) AS rent_count FROM category_wide_zoom_lens JOIN inventory ON category_wide_zoom_lens.sku=inventory.sku JOIN detail ON category_wide_zoom_lens.sku=detail.sku WHERE detail.compatibility IN ('Nikon','Any') AND detail.list_in_catalogue = '1' GROUP BY category_wide_zoom_lens.sku ORDER BY sku