UPDATE问题

[zhuxiaong]

有两个表A，B，想用B表中符合A表条件的数据更新A表数据，
update a set ....
where b.mc like '%' +(select mc from a)+'%'(这个条件怎么写)

[liuyun2003]

update a set a.x=b.mc from a,b where b.mc like where b.mc like '%' +a.mc+'%'
前提必须保证找到的b.mc只有一个。否则要报错。

[hjb111]

update a set... from a,b where b.mc=a.mc

[zhuxiaong]

如果一个的话不要这么复杂了，是多个的

[zjcxc]

update a set ....
where b.mc like '%' +(select top 1 mc from a)+'%'

或
update a set ....
where b.mc like '%' +(select max(mc )from a)+'%'

[zhuxiaong]

不对

[CrazyFor]

有两个表A，B，想用B表中符合A表条件的数据更新A表数据，
update a set a.mc=b.mc ,....
from b where charindex(a.mc,b.mc)>0

[CrazyFor]

有两个表A，B，想用B表中符合A表条件的数据更新A表数据，
update a set a.mc=b.mc ,....
from b where charindex(a.mc,b.mc)>0

[zhuxiaong]

不对，跟我执行的结果一样， 符合条件数据没有全部更新

[zhuxiaong]

蚂蚁搞定啊，

[zhuxiaong]

我自己搞定了，给分哦，还是要谢谢大家的参与