title: how to write inner join query in cakephp
body: <p>below shown is my mysql query.it works well. but I need to do that in cakephp. how can I convert this into cake php </p>
  
  <pre><code>SELECT pp.product_properties_id,ppv.product_property_value_id FROM product_properties pp 
  
  INNER JOIN product_property_values  ppv ON pp.product_properties_id = ppv.properties_id
  
  WHERE pp.property_name='Color' AND ppv.properties_value='Blue' 
  </code></pre>
  
  <p>please help me..</p>