Left Join Question

Yii 1.1 General Discussion
1

I have 2 db table

employee (list of all employees)

empno

lname

fname

evaluation (list of all employees submitted there evaluation)

id

empno(relation to employee)

rate

interpretation

school_year

semester

in my evaluationcontroller i call the employee model


$model=new Employee('search');

		$model->unsetAttributes();  // clear any default values

		if(isset($_GET['Employee']))

			$model->attributes=$_GET['Employee'];


		$this->render('allreports',array(

			'model'=>$model,

                        

		));

and in my employee model search()

i add this left join to show all employee that submitted and not submitted there evaluation


  $criteria->join .= ' LEFT JOIN performance_evaluation p ON t.empno = p.empno AND p.school_year=2 and p.semester=2';

in my cgridview how can i show rate and interpretation

i cnnot retrieve the value of rate and interpretation from my cgriview beacause on my controller i use employee model to use left join and get all submitted and not submitted evaluation.