update salaries s
set s.salary=s.salary*1.1
where s.emp_no in(select emp_no from emp_bonus)
and to_date='9999-01-01'