select pretty_name, type from dotlrn_user_types order by pretty_name select rel_id from dotlrn_users where user_id = :user_id select type from dotlrn_users where user_id = :user_id > update dotlrn_full_user_profile_rels set portal_id = :portal_id where rel_id = (select rel_id from dotlrn_full_users where user_id = :user_id)