y Schwartz
> Cc: mysql@lists.mysql.com
> Subject: Re: Max of Count
>
> This might work for you, Jerry - you're on the right track,
> pretty close.
>
> SELECT prod.prod_id, COUNT(*)
> FROM prod, prod_rel
> WHERE prod.prod_id = prod_rel.prod_id
> GROUP BY prod.prod_i
armington Ave.
Farmington, CT 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
>
> Thi
This might work for you, Jerry - you're on the right track, pretty close.
SELECT prod.prod_id, COUNT(*)
FROM prod, prod_rel
WHERE prod.prod_id = prod_rel.prod_id
GROUP BY prod.prod_id
ORDER BY 2 DESC
LIMIT 1
Be aware that using the LIMIT 1 may be misleading in that if you have
multiple entries w