Select Count(b.topic)

[yanfeifei]

SQL代码

select u.sex,u.individualism,count(b.tpoic),u.Points,u.Experience,u.Charm,u.VisiteTimes,u.LastDate,
u.regdate,u.Imgpath,u.Uemail,u.QQID,u.Individualsignature from Users as u inner join BulletinList as b
on(u.userid=b.userid) and u.userName='超级管理员'GROUP BY u.userid,b.userid

报错“u.Sex' 在选择列表中无效，因为该列既不包含在聚合函数中，也不包含在 GROUP BY 子句中。”

请问要怎么获得count(b.tpoic)发表文章的次数！
谢谢啊！

[jinjazz]

select u.sex,u.individualism,count(b.tpoic),u.Points,u.Experience,u.Charm,u.VisiteTimes,u.LastDate,
u.regdate,u.Imgpath,u.Uemail,u.QQID,u.Individualsignature from Users as u inner join BulletinList as b
on(u.userid=b.userid) and u.userName='超级管理员'GROUP BY u.sex,u.individualism ,u.Points,u.Experience,u.Charm,u.VisiteTimes,u.LastDate,
u.regdate,u.Imgpath,u.Uemail,u.QQID,u.Individualsignature

[vest011]

学习了.

[yanfeifei]

非常感谢！

[yanfeifei]

意思就是说要把select 里用到的字段全部加进GROUP BY 句子里就对啦？

[yanfeifei]

select u.sex,u.individualism,发表文章=count(b.topic),
u.Points,u.Experience,u.Charm,u.VisiteTimes,u.LastDate,
u.regdate,u.Imgpath,u.Uemail,u.QQID,u.Individualsignature from Users as u inner join BulletinList as b
on(u.userid=b.userid) and u.userName='地精商会版主'
GROUP BY u.sex,u.individualism ,u.Points,u.Experience,u.Charm,u.VisiteTimes,u.LastDate,
u.regdate,u.Imgpath,u.Uemail,u.QQID,u.Individualsignature

性别 个人主页 发表文章 财产 用户等级 魅力 登陆次数 最后登陆时间 注册时间
酷哥 NULL 2 888888 80 888888 4 NULL 2008-01-01

个人头像 Email QQ号 个人签名
img/Image2.gif [e-mail] 无 无


但是count为0用户的信息就没啦！
count为0 用户的信息依然存在
要怎么写呢？
谢谢高手指点！