oracle8.1.6 select w.workflow_key, t.pretty_name, w.description, count(c.case_id) as num_cases, 0 as num_unassigned_tasks from wf_workflows w, acs_object_types t, wf_cases c where w.workflow_key = t.object_type and c.workflow_key (+) = w.workflow_key and c.state (+) = 'active' group by w.workflow_key, t.pretty_name, w.description order by t.pretty_name