更新nc_cbry 联系地址

update nc_cbry d set d.lxdz=(select c.xmmc||'  '||trim(b.xmmc)||'  '||trim(a.xmmc)
from xt_tree a,xt_tree b,xt_tree c where a.xmdm=d.dwdm and c.xmdm=d.qydm and a.fbdh=b.xmdh )
where /*d.lxdz is null and*/ d.qydm='12' and d.ybbh='20800013';