帮忙找个错,谢谢
select min(a.CustomersID), a.CustomersName, a.Type1, a.Type2, a.Type3, a.grade, a.tel, a.e_mail, a.address, a.linkman, a.linkMobile,a.mobile, a.Trade, a.Birthday, a.Relationship, a.remark, a.CreateDate, a.Brand, a.SalesVolume, a.CooperaStartime, a.CooperationEndtime, a.Allmobile
,b.cusTypeName as cusType1,c.cusTypeName as cusType2,d.cusTypeName as cusType3 FROM dt_Customers as a left join dt_customerType as b on a.Type1=b.cusTypeId
left join dt_customerType as c on a.Type2=c.cusTypeId left join dt_customerType as d on a.Type3=d.cusTypeId group by a.allmobile,a.CustomersName,a.linkMobile,a.mobile
消息 8120,级别 16,状态 1,第 8 行
选择列表中的列 'dt_Customers.Type1' 无效,因为该列没有包含在聚合函数或 GROUP BY 子句中。