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