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

[Back to original message]