update 表A a
set hbsm =
(select fwbm
from 表B b
where zrzid in
(select zrzid from 表B where q
xdm
= 'yyy')
and zt = 0
and a.zh = b.zrzh
and a.hh = b.hh and rownum=1 and zl like '%水首府1号楼%' )
where a.zid = 'xxx'
我要从表B里面更新数据到表A里面，条件有一条是表A的zh要等于表B里面的zrzh，但是表A的zh是‘9-13幢地下室’，表B的zrzh是‘地下室’，这个要加个什么条件才能更新

顶一下