Yii join

Yii join

$rows = Yii::app()->db->createCommand()
  ->select('j.*, p.orderno, p.category, o.bidno')
  ->from('jobs j')
  ->join('projects p','j.projid = p.projid')
  ->join('orders o', 'p.orderno = o.orderno')
  ->where('j.projid=:id', array(':id'=>$id))
  ->order('j.jobno,j.projid')
  ->queryRow();