title: inner join with cake php 3
body: <p>Help Please , I'm trying to get data from multi tables : first table is contain ( more than 3 tables ) , the second table have data related to the first table . </p>
  
  <p>I have used Inner Join at Php myadmin and it's working fine !
  but when i have return that to cake php , it's doesn't work fine . </p>
  
  <p>here's my code : </p>
  
  <pre><code> $query= $this-&gt;SterilizationTaskOrders-&gt;find('all',array('contain'=&gt;[ 'Users','SterilizationTasks', 'SterilizationTypes', 'SterilizationTaskTypes', 'SterilizationStatuses'],)) -&gt;join([
              'supervision_data' =&gt; [
                  'table' =&gt; 'supervision_data',
                  'type' =&gt; 'INNER',
                  'conditions' =&gt; 'supervision_data.sterilization_task_orders_id =SterilizationTaskOrders.id ',
              ] ])-&gt;toArray();
  </code></pre>
  
  <p>And here's the sql statement which i have used in phpmyadmin and has been worked fine ! </p>
  
  <blockquote>
    <p>SELECT * FROM <code>sterilization_task_orders</code> INNER JOIN <code>supervision_data</code> ON sterilization_task_orders_id =sterilization_task_orders.id</p>
  </blockquote>