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