select A.htname as 户型,
D.dname as 区县,
C.sname as 街道,
B.uname as 姓名
from sys_user as B,hos_type as A,hos_street as C,hos_district as D
group by D.dname消息 8120,级别 16,状态 1,第 1 行
选择列表中的列 'hos_type.htname' 无效,因为该列没有包含在聚合函数或 GROUP BY 子句中。
为什么给我报了一个这样的错误。我四个表连接查询
D.dname as 区县,
C.sname as 街道,
B.uname as 姓名
from sys_user as B,hos_type as A,hos_street as C,hos_district as D
group by D.dname消息 8120,级别 16,状态 1,第 1 行
选择列表中的列 'hos_type.htname' 无效,因为该列没有包含在聚合函数或 GROUP BY 子句中。
为什么给我报了一个这样的错误。我四个表连接查询
当且仅当你要对用户进行分组统计(比如按年龄段求各组的人数,按班级求平均分,按课程求总得分....)时,才要用到GROUP!
另外,你那几个表,是如何连接的?以什么来连接?如果这个都没搞清楚,那请先去学学数据库基础,再学写SQL吧.
D.dname as 区县,
C.sname as 街道,
B.uname as 姓名
from sys_user as B,hos_type as A,hos_street as C,hos_district as D