SQL语句编写：将表B中的一列值更新到表A里的SQL语句怎么写

update A a set a.cellphone=b.phone where a.id in (select b.id from B b where b.stat='Y')