public function job(){
// 实例化model类
$job = M('Job');
$result = $job -> join('LEFT JOIN z_Job ON z_JobType.ID = z_Job.JobType') -> order(array('z_Job.ID' => 'desc')) -> limit(10) -> select();
echo $job -> getLastSql();die;
dump($result);die;
$this->assign('result',$result);
$this->display();
}报这个错SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'z_Job'
麻烦知道是什么错告诉小弟一下
用的框架是3.2.3版本
最佳答案
