title: Cakephp - joining tables, NOT in
body: <p>I'm a newbie and I'm trying to make a Query but don't get it how to do the Query in cake-style. I want to do a query that Selects all respondents thats not in a particular transformational. Examples at the bottom. Cakephp v 2.4.5</p>
  
  <p>I have to three tables/models:</p>
  
  <p>Resondents: id, name</p>
  
  <pre><code>public $hasAndBelongsToMany = array(
      'Transformational' =&gt; array(
          'className' =&gt; 'Transformational',
          'joinTable' =&gt; 'transformationals_respondents',
          'foreignKey' =&gt; 'respondent_id',
          'associationForeignKey' =&gt; 'transformational_id',
          'unique' =&gt; true
      )
  );
  </code></pre>
  
  <p>Transformationals: id, name</p>
  
  <pre><code>   public $hasAndBelongsToMany = array(
      'Respondent' =&gt; array(
              'className' =&gt; 'Respondent',
          'joinTable' =&gt; 'transformationals_respondents',
          'foreignKey' =&gt; 'transformational_id',
          'associationForeignKey' =&gt; 'respondent_id',
          'unique' =&gt; true
          ),
  };
  </code></pre>
  
  <p>TransformationasRespondent: id, transformational_id, respondent_id
      This is a join table</p>
  
  <p>Example tables:
  respondent: id, name
  1, Abc
  2, Def
  3, Ghi
  4, Jkl</p>
  
  <p>transformationals: id, name
  1, Macrosoft
  2, Eddy
  3, Wag</p>
  
  <p>transformationals_respondents: id, respondent_id, transformational_id
  1, 1, 7
  2, 2, 7</p>
  
  <p>THen I need Query to SELECT respondents thats NOT in transformationals_respondents and has transformational_id 7. Ie. respondent Ghi and Jkl</p>
  
  <p>I would really appreciate a hand here.</p>