UPDATE sm_funtouser_tb
SET (user_id, group_code, field_id, authority) =
(
SELECT a.user_id, c.group_code, c.field_id, c.authority  
FROM sm_users_tb a, sm_deggroup_tb b, sm_funcgroup_tb c  
WHERE a.user_degree = b.user_degree                    
  and b.group_code = c.group_code                         
  and c.group_code = '01'
)
위와 같이 실행하면...
ORA-01427: single-row subquery returns more than one row
이런 에러가 발생하거든요..
전체를 갱신하려면 어떻게 해야 하는지 알려 주세여~~