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