<?php
namespace Admin\Model;
use Think\Model\ViewModel;
class InfoputViewModel extends ViewModel {
public $viewFields = array(
'user'=>array('_table'=>"user",'_as' => 'user','id','sid','grade','atime','username','truename','openid','_type'=>'LEFT'),
'gifts'=>array('giftsid','totprice','fright','_on'=>'gifts.openid=user.openid'),
'parent'=>array('_table'=>"user",'_as' => 'parent','username'=>'pname','_on'=>'user.pid=parent.id'),
'union'=>array('_table'=>"user",'_as' => 'union','grade'=>'iname','_on'=>'user.unid=union.id'),
'infoment'=>array('name'=>'sname','_on'=>'infoment.uid=user.sid'),
);
}SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'user'注释掉'union'那行就可以运行了
最佳答案
