Is there a way around this error message?  I am selecting 8 fields (one is a count) 
and I do not want a group by clause.  Without a group by clause or if I leave one of 
the fields out of the group by clause, I receive this error message:

Column 'location_city' is invalid in the select list  because it is not contained in 
an aggregate function and there is no GROUP BY clause.

------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to