select
wc.workflow_case_id, wc.workflow_id, wc.workflow_case_item_id, wc.aux_id, wc.workflow_case_status_item_id, wc.workflow_case_initator_user_id, wc.date_created, wc.last_changed,
w.workflow_status_item_id, w.workflow_group_item_id, w.epnml_element_attribute_id, w.name, w.valid_from, w.valid_to, w.description,
i.value, ii.item_id
from 
fw_workflow w, 
fw_workflow_case wc, 
fw_item i, 
fw_item ii, 
where 
w.workflow_id = wc.workflow_id and 
wc.workflow_case_status_item_id = i.item_id and 
wc.workflow_case_item_id = ii.item_id;