fixed--issue was COUNT. Select COUNT(*) fixed the issue...
--- In flexcoders@yahoogroups.com, Tim Romano <tim_rom...@...> wrote:
>
> 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
> >
>
