On Tue, Mar 18, 2003 at 04:29:13PM +1000, Rudi Starcevic wrote:
<cut>
> What I would like to see is something like:
>
> site a : 0
> site b : 3
> site c : 6
<cut>
Maybe something like this:
select um.site_name,
count(*)-sum(case when usm.cus_id is null then 1 else 0 end) as total
from user_main um
left_join user_sys_messages usm using (cus_id)
group by um.site_name
order by um.site_name;