title: MySQL inner join with two tables
body: <p>I'm very new to MySQL and PHP and I'm struggling with inner joins between two tables. I'm constructing a script that reads an os commerce database and tells me which products is currently on back order. In order for the product to be on back order a value in the products_attributes table is set to '134', however it only reads the product_id and not the product_model which is in the 'products' table.</p>
  
  <pre><code>products_attributes(table name)
    options_values_id
    product_id
  
  products(table name)
    product_id
    product_model
  </code></pre>
  
  <p>I want to select items that have the value of '134' in the products_attributes table then match the product_ids from both tables to get the product_model from the "products" table. I feel like the code is very easy but for some reason I'm struggling with how to construct the query and to display it.</p>