两个表，a和b，字段都为(id,data)
现在要把a表里的data字段用b表里对应id相等的data值更新
语句如下：
update a
set data =
(select data
from b
where id= a.id)
where id in (select id from b);