第一种：

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

第二种：

update salaries as s join emp_bonus as e on s.emp_no=e.emp_no
set salary=salary*1.1
where to_date='9999-01-01'

思路：了解update语句，详解见代码