title: how to write joining two table query in cakephp
body: <pre><code>SELECT e.employee_name, e.employee_store, e.employee_phone, s.store_address
  FROM  `employee` e
  JOIN store s ON e.employee_store = s.store_name
  </code></pre>
  
  <p>How to write this query in cakephp controller and how to display result in view part . </p>