mysql更新语句不能用嵌套吗 请教大家 急！

mysql> update employer set salary=salary+1000 where exists(select * from employer,department where employer.sex='F' and employer.depid=department.id and department.id='123');

这样不行啊 但我必须要完成这样的功能啊，谁能告诉我