两张表更新问题~十万火包

[qq4004229]

update TeachingPractise
set a.textid=b.id
from TeachingPractise as a inner join textarticle as b on a.bookcode =b.code and inputtime='20080505'


错误提示
消息 4104，级别 16，状态 1，第 1 行
无法绑定由多个部分组成的标识符 "a.textid"。

[mylibin]

修改应该不能用连接修改吧

[badtank]

update TeachingPractise
set a.textid=b.id
from textarticle
where TeachingPractise.bookcode =textarticle.code
and inputtime='20080505'

[yangshun2008]

update 里面能有from ???

update TeachingPractise
set TeachingPractise.textid=textarticle.id
where TeachingPractise.bookcode =textarticle.code
and inputtime='20080505'

[qq4004229]

消息 4104，级别 16，状态 1，第 1 行
无法绑定由多个部分组成的标识符 "textarticle.code"。

[贫僧又回来了]

先把你要的字段放入临时表
select ……into #a
再UPDATE TeachingPractise
试试看！呵呵

[m2741454]

update TeachingPractise
set TeachingPractise.textid=b.[id ]
from TeachingPractise inner join textarticle as b on TeachingPractise.bookcode =b.code and inputtime='20080505'

更新的表a.textid 和update TeachingPractise 不相同无法绑定

[songhuan]

update TeachingPractise set textid=
(select id from textarticle where code=(select bookcode from TeachingPractise where inputtime='20080505'  )) 
where inputtime='20080505' 

行不行？

[qq4004229]

好了结帐。。6楼的正解。。。
感谢谢大家