Searching Multiple Unrelated Active Records

Hi All,

I need to search multiple unrelated active records in my site. The search also includes date comparision.

I have easily achieved search queries for single model but have no idea on how to achieve this with multiple models.

Anyone have tried similar extension, please do give a heads up.


You can use JOIN to add two or more models or tables.


$Criteria = new CDbCriteria;

$Criteria->join = 'LEFT JOIN table2 ON table2.test_id =';