|Subject:||OLE error code:80040E14|
|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?