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
[EMAIL PROTECTED]
Increase signal to noise ratio. http://www.targabot.com
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
