postgresql7.3
select count(*)
from evaluation_task_groups etg, evaluation_tasks et
where etg.task_item_id = et.task_item_id
and et.task_id = :task_id
select etg.group_id as from_evaluation_group_id,
g.group_name
from evaluation_task_groups etg, groups g, evaluation_tasks et
where etg.task_item_id = et.task_item_id
and et.task_id = :from_task_id
and etg.group_id = g.group_id
select task_item_id
from evaluation_tasks
where task_id = :task_id
select acs_rel__new (
null,
'evaluation_task_group_rel',
:new_evaluation_group_id,
map.object_id_two,
:package_id,
:creation_user_id,
:creation_ip
)
from acs_rels map where map.object_id_one = :from_evaluation_group_id;