Yii Framework default uses ‘LEFT OUTER JOIN’ in CActiveRelation class for query. But I want to set it to ‘INNER JOIN’ default.
How can I do? Where should I change!
Yii Framework default uses ‘LEFT OUTER JOIN’ in CActiveRelation class for query. But I want to set it to ‘INNER JOIN’ default.
How can I do? Where should I change!
you can pass in the ‘joinType’ option in your relation declaration
'relationName'=>array('RelationType', 'ClassName', 'ForeignKey', 'joinType'=>'INNER JOIN')
Yes, you are right
But I want to change it by default for all relations from ‘LEFT OUTER JOIN’ to ‘INNER JOIN’ permanent.