I have two tables in cakePHP. competencies ------------ id name
competenceRatings ----------------- id competence_id user_id rating I need a way to write the following query in the cake way: SELECT * FROM competencies WHERE id NOT IN (SELECT competence_id FROM competence_ratings WHERE employee_id = $userId) Someone please help me!! -- View this message in context: http://cakephp.1045679.n5.nabble.com/CakePHP-nesting-two-select-queries-tp5710154.html Sent from the CakePHP mailing list archive at Nabble.com. -- 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 [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
