Cakephp - joining tables, NOT in <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>