title: SQL many to many select
body: <pre><code>category_product
  ---------------
  id_category
  id_product
  
  product
  ---------------
  id_product
  id_manufacturer
  
  manufacturer
  ---------------
  id_manufacturer
  name
  </code></pre>
  
  <p>How would I create an SQL query so that it selects all the names from manufacturer when id_category is equal to something?</p>