Cactiverecord Model With Join In Relation

Yii 1.1 General Discussion
1

Hi all,

I have a relation in one of my CActiveRecord models that requires a simple INNER JOIN.

Expressed as an SQL statement the relation would look like this:

“SELECT * FROM T1 INNER JOIN T2 ON T2.related_id = T1.id WHERE T2.status = ‘1’”

With ‘T1’ being the table I want a list of records for, and my model being a CActiveRecord instance of ‘T2’.

How can I put that into a CActiveRecord relation?

Thanks!

2

hi

$criteria=new CDbCriteria;

$criteria->join ='INNER JOIN T2 ON T2.related_id = T.id;

$criteria->condition = " T2.status = ‘1’ ";

3

Thanks n-r for the reply but I wasn’t clear enough in my initial post. What I need is to do this in the “relations()” function in my model class that extends CActiveRecord i.e.




public function relations()

{

    return array(

                 'author'=>array(self::BELONGS_TO, 'User', 'author_id'),

                );

}