Column 'ttid' in where clause is ambiguous
多半是因为多表查询的时候几个表中同时出现了某个相同的列名,
而在查询条件WHERE后面又没有指定是那个表,
而引起的又或者是查询结果里面有两个相同的列名,而没有指定是哪个表,使用的时候可以这样,查询前面加表名可避免出现错误
ambiguous 1. 含糊不清的 2. 引起歧义的
select distinct username,UserAlias,OrganName,OrganLevelName,jobname,
DATE_FORMAT(StartDate,'%Y-%m-%d %H:%i') StartDate,
DATE_FORMAT(FinishedDate,'%Y-%m-%d %H:%i') FinishedDate,
TopicCount,doCount2, rightCount,rightRate ,
Finishedrate,ttc.UserID,OrganID from vz019TTCount ttc
inner join Vuser u on ttc.userid = u.userid inner join tbTTGrade ttg
on ttc.ttid = ttg.ttid and ttc.userid = ttg.userid
where ttg.finishedmode=1 and ttc.ttid=41
order by OrganName,Department