select rel_id, rel_type, object_id_one from acs_rels where object_id_two = :from_user_id and object_id_one not in (select object_id_one from acs_rels where object_id_two = :to_user_id ) UPDATE cr_items SET parent_id = :to_fs_root_folder WHERE parent_id = :from_fs_root_folder UPDATE cr_items SET parent_id = :to_fs_shared_folder WHERE parent_id = :from_fs_shared_folder select item_id, name from cr_items where parent_id = :from_fs_root_folder and name in (select name from cr_items where parent_id = :to_fs_root_folder); select rel_id, rel_type, object_id_one from acs_rels where object_id_two = :user_id select c.community_id from acs_rels r, dotlrn_communities c where r.object_id_one = :contact_id and r.object_id_two = c.community_id