Counts, distincts and hasManys...

Hi there,

I've been away from Cake for a bit and am coming back to a project and am scratching my head with this one...

I have the following set up:

Alumni -> hasMany -> Courses

The alumni rows have a 'checked' field and courses have a 'year' field.

I need to get the distinct years from courses the number of alumni rows attached to that year that have 0 in the checked field...

Can anyone give me any pointers of how to go about this?

TIA!

--
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 cake-php+unsubscribe@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en-US.