06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 31, 2006 5:49 PM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: Max of Count
This might work for you, Jerry - you're on the right track
- WHERE prod.prod_id = prod_rel.prod_id GROUP BY
prod_rel.prod_id)
- AS t;
and got
ERROR 1140 (42000): Mixing of GROUP columns
(MIN(),MAX(),COUNT(),...) with
no
GROUP columns is illegal if there is no GROUP BY clause
I had a feeling that I couldn't just use id in the outer
, prod_rel.prod_id as id
- FROM prod, prod_rel
- WHERE prod.prod_id = prod_rel.prod_id GROUP BY prod_rel.prod_id)
- AS t;
and got
ERROR 1140 (42000): Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with
no
GROUP columns is illegal if there is no GROUP BY clause
I had a feeling that I
;
and got
ERROR 1140 (42000): Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with
no
GROUP columns is illegal if there is no GROUP BY clause
I had a feeling that I couldn't just use id in the outer select, but how do
I get it? I tried adding GROUP BY t.prod_id, but that just gave me the same
error
