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)
使用update更新数据，再来熟系一下update的语法：update table_name set ‘column’=‘value’ where condition