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

alter table 是用来增加列和删减列的 而update---set---是用来改变数据的