|
|
Posted by Pierre on 11/16/06 18:14
Captain Paralytic <paul_lautman@yahoo.com> wrote:
> KrunoG wrote:
> > I just don't see how could any of sql's recognize this query, 'cause there
> > is no way that you could successfully join "count (*) of something" with a
> > field in another table.
>
> But he wasn't. He was joining on the id and client fields.
Indeed, I count ticktes per client, then join. Any idea why MySQL 5.x
returns that error: #1054 - Unknown column 'c.id' in 'on clause',
whereas 4.1.x doesn't ? I still can't figure out!
--
Pierre
Navigation:
[Reply to this message]
|