update cu SET row_status = '2' FROM course_users cu INNER JOIN course_main cm ON cu.crsmain_pk1 = cm.pk1 INNER JOIN users u ON cu.users_pk1 = u.pk1 WHERE cm.course_id LIKE '%FA2010%' AND course_users.data_src_pk1 < '20' AND u.user_id not like 'stu_%' AND u.user_id not like '%student%' AND u.user_id not like '%faculty%' AND u.user_id <> 'bross' AND u.user_id NOT LIKE 'temp-olw%' AND cu.role = 'S' AND u.institution_roles_pk1 = '1'
No comments:
Post a Comment