title: Select count of column grouped by another column SQL
body: <p>I have two tables, one called Products and one called Products_Category. I want to show the inventory count for each category (grouped by category), and also display the name of the category. The Products table has the inventory count for each Product, but the Products_Category table has the Category names. How can I display the two together? Should I be using some kind of join?</p>
  
  <p>Here's what I'm trying to get:</p>
  
  <p>Category_Name --------- Sum(Products_Inventory)  </p>
  
  <p>------Books --------------------  1  ----------<br>
  ------Toys----------------------  2  ----------  </p>
  
  <p>But as of right now all I'm able to display is the category <em>ID</em> instead of the category <em>name</em>, like so:  </p>
  
  <p>------- 1 ------------------------ 1 ----------<br>
  ------- 2 ------------------------ 2 ----------</p>