oracle8.1.6 select tr.transition_name, tr.transition_key, to_char(cd.deadline, :date_format) as deadline_pretty, '' as edit_url, '' as remove_url from (select c.case_id, tr.sort_order, tr.transition_name, tr.transition_key, tr.workflow_key from wf_cases c, wf_transitions tr where c.case_id = :case_id and c.workflow_key = tr.workflow_key) tr, wf_case_deadlines cd where tr.case_id = cd.case_id(+) and tr.transition_key = cd.transition_key(+) and tr.workflow_key = cd.workflow_key(+) order by tr.sort_order