Re: group by weirdness

Josh Berkus wrote:
> Joseph,
> 
> The subject line could describe a lot of what I see outside my house
> every day (I live in San Francisco CA).
> 
> 
>>Could someome explain these error messages to me?  Why am I being
>>asked to group by j.id? 
>>
> 
> Because you've asked the db engine to count on mj.mid.  The parser want
> you to be specific about whether the other columns are being aggregated
> or not.

But they are in seperate tables, so how could it think they could be aggregated together?



-- 
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio.  http://www.targabot.com