postgresql7.4
DELETE FROM dotfolio_group_adviser_map WHERE group_id = :group_id
select u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as member_name
from dotfolio_groups g,
group_member_map m,
cc_users u
where g.group_id = m.group_id
and g.group_id = :group_id
and m.member_id = u.user_id