title: cakePHP table joining two tables issue
body: <p>Im new to cakePHP and the whole table relations concept is very confusing!</p>
  
  <p>I have 2 tables, competencies and competenceRatings. competencies stores a list of names with ids. </p>
  
  <pre><code>competencies
  ------------
  id
  name
  </code></pre>
  
  <p>And users can select various competencies from this table and rate them and their ratings are stored into competenceRatings table.</p>
  
  <pre><code>competenceRatings
  -----------------
  id
  competence_id
  user_id
  rating
  </code></pre>
  
  <p>I want to be able to get the names of competencies for which a user have NOT made any ratings into competenceRatings table. i.e., I need list of names from competencies table for which there are no entries in comptenceRatings table(for given user_id).</p>
  
  <p>I tried competencies->hasMany->competenceRatings, competenceRatings->belongsTo->competencies relations.</p>
  
  <pre><code>$competencies = $this-&gt;Competence-&gt;CompetenceRating-&gt;find('all',array('CompetenceRating.user_id' =&gt; $userId,'CompetenceRating.competence_id !=' =&gt; 'Competence.id'));
  </code></pre>
  
  <p>But no use!</p>
  
  <p>Does this result require any other relations? Or can i just join tables using joins condition in find query?</p>
  
  <p>Thanks.</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>This method worked:</p>
  
  <pre><code>$options['joins'] = array(
      array(
          'table' =&gt; 'competence_ratings',
          'alias' =&gt; 'CompetenceRating',
          'type' =&gt; 'LEFT OUTER',
          'conditions' =&gt; array(
              'Competence.id = CompetenceRating.competence_id',
              'CompetenceRating.user_id' =&gt; $userId
          )
      )
  );
  $options['conditions'] = array( 'CompetenceRating.competence_id'=&gt; null );
  </code></pre>