title: MySQL join many to many single row
body: <p>I have 3 tables that I want to combine, see below for details:</p>
  
  <h2>product</h2>
  
  <ul>
  <li>productID </li>
  <li>name </li>
  <li>price</li>
  </ul>
  
  <h2>prod_cat</h2>
  
  <ul>
  <li>productID </li>
  <li>categoryID</li>
  </ul>
  
  <h2>category</h2>
  
  <ul>
  <li>categoryID </li>
  <li>name</li>
  </ul>
  
  <h2>joined</h2>
  
  <p>product.productID category.categoryID product.name product.price category.name(each one though, since a product can belong to more than one category)</p>
  
  <p>What I want to do is get each product with the categories that relate to them in a single query. How would I got about this?</p>