title: Join 3 tables with MySQL
body: <p>I have the following tables:</p>
  
  <pre><code>Products
  prod_id  |  prod_name  |  prod_price
  
  
  Supermarket
  supermarket_id  |  name  |  address
  
  
  supermarket_product
  supermarket_id | product_id
  </code></pre>
  
  <p>How can I join those tables to get a table that shows all the information from Products and Supermarket tables in 1 single big table? I am basically trying to have a table only to hold which product belongs to which supermarket based on it.</p>
  
  <p>I tried the following, but it doesn't work:</p>
  
  <pre><code>SELECT prod_name, prod_price, supermarkets.name 
  FROM products 
  INNER JOIN supermarkets 
      ON supermarket_product.supermarket_id = supermarket.supermarket_id;
  </code></pre>