update b set value=a.value from 表A a inner join 表B b on CHARINDEX(a.[key],b.title)>0 where b.ord in(select top 20 ord from 表B order by ord desc)
update b set value=a.value from a , (select top 20 * from b order by ord desc)b where charindex(a.key,b.title)>0
多谢 fredrickhu 继续试
try: update b set value=a.value from 表A a inner join 表B b on CHARINDEX(a.[key],b.title)>0 where b.ord in(select top 20 b.ord from 表A a inner join 表B b on CHARINDEX(a.[key],b.title)>0 order by b.ord desc)
where b.ord in(select top 20 ord from 表B order by ord desc)
b
set
value=a.value
from
a ,
(select top 20 * from b order by ord desc)b
where
charindex(a.key,b.title)>0
继续试
update b set value=a.value from 表A a inner join 表B b on CHARINDEX(a.[key],b.title)>0
where b.ord in(select top 20 b.ord from 表A a inner join 表B b on CHARINDEX(a.[key],b.title)>0 order by b.ord desc)