In many cases when we want to formulate complex queries, that need joins between tables, we can still add joins on the fly by adding it to the call of find $students_of_grade = $this->User->find('list',array( 'fields'=>array('UserData.user_id'), 'joins'=>array( array( … Continue reading CakePHP joining tables