dapeng
有人吗 问个问题
public function actionIndex() { $criteria=new CDbCriteria; $criteria->select="t.*,oa_department.name as bname"; //$criteria->condition="id=:id"; //$criteria->params+=array(':id'=>5);//查询条件 $criteria->join="left join oa_department ON t.department=oa_department.id"; $criteria->order='id DESC'; $dataProvider=new CActiveDataProvider('Staff',array( 'criteria'=>$criteria, ) ); $this->render('index',array( 'dataProvider'=>$dataProvider, )); }
这是我构造的sql语句 我上面的语句是从这里出来的 不知道问题在哪里