By their very nature aggregate functions require a group by. If you have no
group by, then the
entire recordset is the group and location_city would make no sense unless
your entire recordset has the same value
for location_city
----- Original Message -----
From: "Kathy Bergman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 23, 2000 9:19 AM
Subject: Group by problem in select query
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/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send
a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
