What happens if you don't put any quotes around the column aliases? Tim
On 1/19/2010 4:55 PM, charliecrystle wrote:
Weird issue: I have a query that works fine--produces expected results:SELECT COUNT(tagsLU.tagid) as 'tagcount', tag.tagname as 'tagname' FROM TagsLU Inner Join tag on tag.tagid=tagslu.tagid Group By tag.tagname Order By tagcount DESC
