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