在线等待~关系SQL视图创建问题
对着参考书创建出版商信息视图
用企业管理器创建视图
在SQL关系格里
SELECT dbo.titles.advance, dbo.titles.price, dbo.publishers.pub_name
FROM dbo.titles INNER JOIN
dbo.publishers ON dbo.titles.pub_id = dbo.publishers.pub_id
group by dbo.publishers.pub_name
having sum(dbo.titles.advance)> $2500 and avg(dbo.titles.price)> $15
但是我运行sql√显示成功
运行!显示
列 'dbo.titles.advance '在列表中无效,因为该列既不包含在聚合函数,也不包括在group by子句中
求各为大大解释怎么回事?
[解决办法]
SELECT sum(dbo.titles.advance) as sumadvance
,avg(dbo.titles.price) as avgprice, dbo.publishers.pub_name
FROM dbo.titles INNER JOIN
dbo.publishers ON dbo.titles.pub_id = dbo.publishers.pub_id
group by dbo.publishers.pub_name
having sum(dbo.titles.advance)> $2500 and avg(dbo.titles.price)> $15
