select c.cnname, CustName=a.chinaname , title=a.title_c,
companyName= a.company_c , a.inputnum,a.FallNumList
from t_mate_regist a,t_regist b,t_base_nation c
where a.nation=c.code and a.regid=b.regid and b.teamid is null
and b.class=10 and b.type=10 and (a.chinaname= '许金诸 ' or a.englishname= '许金诸 ')
group by a.company_c
having count(*)> 1
order by company_c
========================
消息 8120，级别 16，状态 1，第 1 行
选择列表中的列 't_base_nation.CnName ' 无效，因为该列没有包含在聚合函数或 GROUP BY 子句中。
=======================
------解决方案--------------------
select c.cnname, CustName=a.chinaname , title=a.title_c,
companyName= a.company_c , a.inputnum,a.FallNumList
from t_mate_regist a,t_regist b,t_base_nation c
where a.nation=c.code and a.regid=b.regid and b.teamid is null
and b.class=10 and b.type=10 and (a.chinaname= '许金诸 ' or a.englishname= '许金诸 ')
group by a.company_c,c.cnname,a.chinaname,a.title_c,a.inputnum,a.FallNumList
having count(*)> 1
order by company_c
------解决方案--------------------
除company_c列外,其它输出列用聚合函数或也在group by 语句中,例如:
select max(c.cnname) as cnname,
CustName=max(a.chinaname),
title=max(a.title_c),
companyName= a.company_c ,
max(a.inputnum) as inputnum,
max(a.FallNumList) as FallNumList
from t_mate_regist a,t_regist b,t_base_nation c
where a.nation=c.code and a.regid=b.regid and b.teamid is null
and b.class=10 and b.type=10 and (a.chinaname= '许金诸 ' or a.englishname= '许金诸 ')
group by a.company_c
having count(*)> 1
order by company_c
------解决方案--------------------
select c.cnname, CustName=a.chinaname , title=a.title_c,
companyName= a.company_c , a.inputnum,a.FallNumList
from t_mate_regist a,t_regist b,t_base_nation c
where a.nation=c.code and a.regid=b.regid and b.teamid is null
and b.class=10 and b.type=10 and (a.chinaname= '许金诸 ' or a.englishname= '许金诸 ')
group by a.company_c,c.cnname,a.chinaname,a.title_c,a.inputnum,a.FallNumList
having count(*)> 1
order by company_c
------解决方案--------------------