oracle8.1.6 select eg.grade_id, eg.item_id, eg.grade_plural_name, eg.comments, eg.weight, cri.live_revision from evaluation_gradesx eg, acs_objects ao, cr_items cri where eg.item_id = ao.object_id and eg.grade_item_id = cri.item_id and (cri.live_revision = eg.grade_id or cri.latest_revision = eg.grade_id) and ao.context_id = :package_id $orderby select nvl(sum(eg.weight),0) as total_weight from evaluation_gradesi eg, acs_objects ao where content_revision.is_live(eg.grade_id) = 't' and ao.context_id = :package_id and eg.item_id = ao.object_id select nvl(sum(eg.weight),0) from evaluation_gradesx eg, acs_objects ao where content_revision.is_live(eg.grade_id) = 't' and eg.item_id = ao.object_id and ao.context_id = :package_id