Re: 7.3 "group by" issue

----- Original Message -----
From: "Dan Langille" <dan(at)langille(dot)org>
To: <pgsql-sql(at)postgresql(dot)org>
Sent: Friday, February 21, 2003 7:01 PM
Subject: [SQL] 7.3 "group by" issue

> Hi folks,
>
> This query:
>
> SELECT element_id as wle_element_id, COUNT(watch_list_id)
> FROM watch_list JOIN watch_list_element
> ON watch_list.id = watch_list_element.watch_list_id
> AND watch_list.user_id = 1
> GROUP BY watch_list_element.element_id

Try:

SELECT element_id as wle_element_id, COUNT(watch_list_id)
FROM watch_list JOIN watch_list_element
ON watch_list.id = watch_list_element.watch_list_id
WHERE
watch_list.user_id = 1
GROUP BY watch_list_element.element_id

Ciao
Gaetano