这是什么问题？

[phoenix8122]

Microsoft VBScript 编译器错误 错误 '800a03f6'

缺少 'End'

/iisHelp/common/500-100.asp，行242

Microsoft OLE DB Provider for SQL Server 错误 '80040e14'

Column 'first.name' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

我用group by 语句就出现这个问题，是什么意思啊，怎么解决？

[伍子V5]

select col1,col2,sum(col3) from tablename group by col1,col2
注意，col1,col2都要包括在group by 字句里面

[txlicenhe]

select col1,col2,sum(col3) from tablename group by col1,col2
注意，col1,col2都要包括在group by 字句里面
且包括在group by 里面的字段都要在select 和 from 之间
eg:
select col1,col2,sum(col3) from tablename group by col1,col2
select col1,sum(col3) from tablename group by col1,col2 -- error
select col1,col2,sum(col3) from tablename group by col1 -- error

[愉快的登山者]

你的原句？

[sdhdy]

要么把first.name去掉，要么group by 后加上first.name,要么把first.name改为max(first.name)

[gmlxf]

group by first.name

[phoenix8122]

不好意思用错语句了!!