为什么我这条分组显示语句有错误？急死...

[情绝书生]

Sql="Select ID,ArtistName,Years,count(ArtistName) as n From Artist where ArtistName like '"&request.QueryString("let")&"%' Group by ArtistName order by ArtistName"

Microsoft JET Database Engine 错误 '80040e21'

试图执行的查询中不包含作为合计函数一部分的特定表达式 'ID' 。

/search.asp，行 193

[agaovxy]

Group by ArtistName 去掉

[哈哈]

Sql="Select ID,ArtistName,Years,count(ArtistName) as n From Artist where ArtistName like '"&request.QueryString("let")&"%' Group by ArtistName,ID order by ArtistName"
----------------
Group by ArtistName,ID
输出字段一定要包含在GROUP BY 中