title: CakePHP 3.0 how to contain a left outer join
body: <p>Suppose that <code>Candidates</code> has one field named <code>Ratings</code>.
  The association is optional.</p>
  
  <p>I want all <code>Candidates</code> having a rating other than 0 or no rating at all
  and to contain the ratings in the result.</p>
  
  <p>I managed to get the right query for the first part by coding a left outer join like this:</p>
  
  <pre class="lang-php prettyprint-override"><code>$this-&gt;Candidates
    -&gt;find('all')
    -&gt;leftJoin(
      ['Ratings' =&gt; 'ratings'],
      [
        'Ratings.candidate_id = Candidates.id',
        'Ratings.rating = 0',
      ],
      ['Ratings.rating' =&gt; 'integer'])
    -&gt;where('Ratings.id IS NULL');
  </code></pre>
  
  <p>However I failed to get the rating <em>contained</em> within the result. How can that be done?</p>