Related Records


I am having some issues with a query I need to do -

Suppose I have three tables - posts, authors and author_types. Posts and authors have Many-to-One relation. And authors and author_types have one-to-one relation.

I need to pull posts based on the following criteria - the date of posts are within a range, and the authors of those posts are of a certain author type.

Author types are listed in the author_types table off course.

I have models for all of them.

Now, how am I going to accomplish this?

Please help - my head is hurting trying to figure out the joins I need to put in the CDBCriteria.

Thanks much!