sql ="select a.Username,a.Img,a.Id,a.Shijian,b.Title,b.Content,b.Shijian,b.Userid,b.Moduleid,count(b.id) as tongji from Usera as a,Article as b where b.id='"&id1&"' and b.Moduleid='"&id&"' and b.Userid= a.id "'a.Username' 在选择列表中无效,因为该列未包含在聚合函数中,并且没有 GROUP BY 子句。
这个应该怎么修改了
请大虾们指教下
这个应该怎么修改了
请大虾们指教下
group by a.Username,a.Img,a.Id,a.Shijian,b.Title,b.Content,b.Shijian,b.Userid,b.Moduleid "
要麼分組 group by a.Username,a.Img,a.Id,a.Shijian,b.Title,b.Content,b.Shijian,b.Userid,b.Moduleid
要麼 去掉count(b.id)