以下应如何修改

[99_mei]

update TBADDRESS set ztitle=(SELECT top 1 tem.ztitle from TBADDRESS tem where tem.zid='W000000451') where zid='W000000456'是有错呀。提示为：操作必须使用一个可更新的查询。。

[pengdali]

update TBADDRESS set TBADDRESS.ztitle=(SELECT top 1 tem.ztitle from TBADDRESs tem where tem.zid='W000000451') where TBADDRESS.zid='W000000456'


你的TBADDRESS是什么东西？视图？

[pengdali]

update TBADDRESS set ztitle=tem.ztitle from (SELECT top 1 ztitle from TBADDRESs where zid='W000000451') tem where TBADDRESS.zid='W000000456'

[99_mei]

TBADDRESS是个表名

[wzh1215]

declare @ss varchar(100)
select @ss=ztitle from TBADDRESS where zid='W000000451'
update TBADDRESS set ztitle=@ss where zid='W000000456'

[friendliu]

应该没错
我刚才试了一下。

[j9988]

应该没错.不是原语句吧.

除非TBADDRESS也是一个查询结果,且有GROUP BY或TOP之类.