UPDATE salaries s
SET s.salary = 1.1*s.salary
WHERE s.to_date = '9999-01-01'
AND s.emp_no IN (SELECT emp_no FROM emp_bonus)