$criteria=new CDbCriteria(array(
'select'=>'user_info.name, user_info.title, user_info.avatar_small',
'join'=>'LEFT JOIN user_info ON user_info.userid = userid ',
'condition'=>'deptid='.$t,
));
$teachers = Dept_users::model()->findAll($criteria);
Dept_users表与user_info都存在userid,如何Join?
直接写成如下方式,会报错,不认识dept_users.userid
'join'=>'LEFT JOIN user_info ON user_info.userid = dept_users.userid ',
请教