CakePHP nesting two select queries?

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
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php