【SQL开源代码栏目提醒】:本文主要为网学会员提供255.sql,希望对需要255.sql网友有所帮助,学习一下!
update tb_employee12 set 奖金=奖金+100 where 职工 in
(select 职工 from tb_particular12 where 职工=tb_employee12.职工
and 工龄>=5 or 职工 in (select 职工 from tb_particular12 where
职工=tb_employee12.职工 and 受表扬次数>4))