I have an SQL statement that returns the number of employees in each department, but it only returns the departments that have employees. Is there any way to have the SQL statement return all 60 departments even if there are no employees. Thanks.<BR><BR>select ftr_description, wk_pager_no, wk_end_date, count(wk_id_code) as idcount<BR>from f_trades, f_personnel<BR>where wk_ftr_fk = ftr_pk<BR>group by ftr_description, wk_pager_no, wk_end_date<BR>having wk_pager_no = &#039;BEN&#039; and wk_end_date is null;<BR>