update Employee t0 LEFT join EmployeeDetail t1 on (t1.id=t0.id)
set t0.status=1, t1.salary=t1.salary+10000
where t1.salary < 50000 and t1.status=0

update Employee set status=1
where id in (select t0.id from
Employee t0 LEFT join EmployeeDetail t1 on (t1.id=t0.id)
where t1.salary < 50000 and t1.status=0)

update EmployeeDetail set salary=salary+10000
where id in (select t1.id from
Employee t0 LEFT join EmployeeDetail t1 on (t1.id=t0.id)
where t1.salary < 50000 and t1.status=0)