group by problem!!!

i'd like to obtain on the same line of my sql select query:

select sector,count(event) closed,count(event) all_events from table
group by sector

but all_events is for all events of course (no where clause on the status) and closed is only for events with status 'C'

i did it with a union select but i obtain 2 lines...

how can i do ???

thanks Received on Fri Aug 17 2001 - 03:37:14 CDT