求SQL语句,比较简单!
表A:

name
dept

表B:

name
dept

我想用一条update语句修改掉所有表B的dept,从表A里查到,name字段相互对应!

[解决办法]
update b
set dept=a.dept
from 表A a inner join 表b b
on a.name=b.name
[解决办法]
update b
set dept = a.dept
from b,a
where b.name = a.name
[解决办法]
update b
set dept=a.dept
from 表A a inner join 表b b
on a.name=b.name

[解决办法]
update b set dept = a.dept from tab1 as a inner join tab2 as b
on (a.name = b.name)
[解决办法]
update b set dept = a.dept from (select * from tab1 as a inner join tab2 as b
on a.name = b.name)

[解决办法]
你表的dept 的型是啥？

下

Update B Set dept = Left((Select dept From A Where name = B.name), 8000)
[解决办法]
楼主把varchar改为text试试!