Re: 7.3 "group by" issue - Mailing list pgsql-sql

----- Original Message ----- 
From: "Dan Langille" <dan@langille.org>
To: <pgsql-sql@postgresql.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