Hello,
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!
Raihan