Im new to cakePHP and the whole table relations concept is very confusing! I have 2 tables, competencies and competenceRatings. competencies stores a list of names with ids.
competencies ------------ id name And users can select various competencies from this table and rate them and their ratings are stored into competenceRatings table. competenceRatings ----------------- id competence_id user_id rating 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). I tried competencies->hasMany->competenceRatings, competenceRatings->belongsTo->competencies relations. $competencies = $this->Competence->CompetenceRating->find('all',array('CompetenceRating.user_id' => $userId,'CompetenceRating.competence_id !=' => 'Competence.id')); But no use! Does this result require any other relations? Or can i just join tables using joins condition in find query? Thanks. -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php