因为该列没有包含在聚合函数或 GROUP BY 子句中。 啥意思？？

[lijing3333]

select a.Accounts,(avg(b.WinCount)+avg(b.LostCount)+avg(b.DrawCount)+avg(b.FleeCount)) as GameCount from QPGameUserDB.dbo.AccountsInfo as a inner join QPTreasureDB.dbo.GameScoreInfo as b on a.UserID=b.UserID

错误信息：无效，因为该列没有包含在聚合函数或 GROUP BY 子句中。

这个什么原因啊 报这个错 是啥意思 没怎么懂

[ForFumm]

a.Accounts 不唯一, AVG 需要分组求平均


select a.Accounts,(avg(b.WinCount)+avg(b.LostCount)+avg(b.DrawCount)+avg(b.FleeCount)) as GameCount from QPGameUserDB.dbo.AccountsInfo as a inner join QPTreasureDB.dbo.GameScoreInfo as b on a.UserID=b.UserID
GROUP BY a.Accounts

[打一壶酱油]

select a.Accounts,(avg(b.WinCount)+avg(b.LostCount)+avg(b.DrawCount)+avg(b.FleeCount)) as GameCount from QPGameUserDB.dbo.AccountsInfo as a inner join QPTreasureDB.dbo.GameScoreInfo as b on a.UserID=b.UserID
GROUP BY a.Accounts

[叶子]

--两种解决方式：
--1、
select a.Accounts,(avg(b.WinCount)+avg(b.LostCount)+avg(b.DrawCount)+avg(b.FleeCount)) as GameCount from QPGameUserDB.dbo.AccountsInfo as a inner join QPTreasureDB.dbo.GameScoreInfo as b on a.UserID=b.UserID group by a.Accounts
--2、
select min(a.Accounts),(avg(b.WinCount)+avg(b.LostCount)+avg(b.DrawCount)+avg(b.FleeCount)) as GameCount from QPGameUserDB.dbo.AccountsInfo as a inner join QPTreasureDB.dbo.GameScoreInfo as b on a.UserID=b.UserID

[--小F--]

select
 a.Accounts,(avg(b.WinCount)+avg(b.LostCount)+avg(b.DrawCount)+avg(b.FleeCount)) as GameCount 
from
 QPGameUserDB.dbo.AccountsInfo as a 
inner join
 QPTreasureDB.dbo.GameScoreInfo as b 
on
 a.UserID=b.UserID group by a.Accounts

[chuanzhang5687]

sql语句后面加个group by a.Accounts

[wujianfeng32]

哥服了you

[sunshinebean]

看看2L怎么写的