> 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 l
t; <[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 on
> I am selecting 8 fields (one is a count) and I do not want a group by
clause.
Kathy,
You have to have a GROUP BY if you are using COUNT(). It's an aggregate
function -
that means it's meaningless without a GROUP BY. What are you trying to do?
Nick
***
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 bec
4 matches
Mail list logo
