oracle8.1.6 select ev.party_id, evaluation.party_name(ev.party_id,et.task_id) as party_name, round(ev.grade,2) as grade, ev.last_modified as evaluation_date, to_char(ev.last_modified, 'YYYY-MM-DD HH24:MI:SS') as evaluation_date_ansi, et.online_p, et.due_date, ev.evaluation_id, et.forums_related_p, (select description from evaluation_student_evalsx where evaluation_id=ev.evaluation_id) as comments from evaluation_tasks et, evaluation_student_evalsi ev, $roles_table cr_items cri where et.task_id = :task_id and et.task_item_id = ev.task_item_id $roles_clause and cri.live_revision = ev.evaluation_id $orderby select crr.filename as answer_data, ea.title as answer_title, ea.revision_id, to_char(ea.creation_date, 'YYYY-MM-DD HH24:MI:SS') as submission_date_ansi, ea.last_modified as submission_date from evaluation_answersi ea, cr_items cri, cr_revisions crr where ea.party_id = :party_id and crr.revision_id = ea.answer_id and ea.task_item_id = :task_item_id and cri.live_revision = ea.answer_id select ev.party_id, evaluation.party_name(ev.party_id,et.task_id) as party_name, crr.filename as answer_data, crr.title as answer_title, ev.revision_id, to_char(ev.last_modified, 'YYYY-MM-DD HH24:MI:SS') as submission_date_ansi, et.due_date, ev.last_modified as submission_date from evaluation_answersi ev, evaluation_tasks et, $roles_table cr_items cri, cr_revisions crr where ev.task_item_id = et.task_item_id and et.task_id = :task_id and crr.revision_id = ev.answer_id and crr.filename is not null $roles_clause and cri.live_revision = ev.answer_id $processed_clause $orderby_wa