SQL语句错误(在线等)
请大家帮忙看一下,下面这个语句在SQL中如何表示:
strSQL = "SELECT Count(Topics.T_Replies) AS cnt FROM Topics HAVING Topics.Forum_id = " & rs("Forum_ID")
提示错误是:
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]列 'Topics.Forum_id' 在 HAVING 子句中无效,因为该列未包含在聚合函数中,并且没有 GROUP BY 子句。