The documentation you are referring to is misleading - a join is only used across a belongsTo association (and hasOne), never for hasMany.
Basically, you can't have query conditions across a hasMany association. You will have to either query the other way (as you saw, the Course belongsTo Term, so you can put Term conditions in the Course query), or do the filtering in PHP after retrieving all data. The Containable behaviour will not help with this - it really just does some tricky bind / unbind and sets the appropriate recursive for the query, it won't help with conditions. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---