Question : yii app db createcommand join yii1
Answered by : muhammad-waseem
$user = Yii::app()->db->createCommand() ->select('id, username, profile') ->from('tbl_user u') ->join('tbl_profile p', 'u.id=p.user_id') ->where('id=:id', array(':id'=>$id)) ->queryRow();
Source : | Last Update : Thu, 29 Oct 20