OLE error code:80040E14

Giganews Newsgroups
Subject: OLE error code:80040E14
Posted by:  neutra‚Ķ@gmail.com
Date: 28 Aug 2006


I am getting the following error:

OLE error code:80040E14 in Microsoft OLE DB Provider for SQL Server
      Column 'tags.id' is invalid in the select list because it is not
contained in either an aggregate function or the GROUP BY clause.

when trying to execute the following query:

select tags.id, name, count(*) as count from taggings, tags where
tags.id = tag_id group by tag_id

The above query works fine on MySQL, but chokes on SQL Server.

Could anyone please help?