＃＃＃请教一个sql问题。谢谢！＃＃＃

[asp2006boy]

UPDATE shop_book.dingjia
SET shop_book.dingjia = shop_book1009.dingjia
WHERE (shuming = shop_book1009.shuming)

我的需求是：在一个数据库里有两个表，分别是shop_book和shop_book1009它们都有一个共同的dingjia字段，我想把shop_book1009里的dingjia全部更新到shop_book的dingjia字段里面，条件是shop_book里面的shuming字段匹配shop_book1009里面的shuming字段。谢谢！
上面的sql是我写的，但是肯定不对。

[asp2006boy]

我是想直接在企业管理器里面运行sql.谢谢

[李向荣]

UPDATE shop_book
SET shop_book.dingjia =
(select dingjia from shop_book1009
where shop_book1009.shuming = shop_book.shuming
)

[asp2006boy]

回复“lxrxyls(行云流水) ”
sqlserver说当子查询跟随在=,之后，或子查询用作表达式时，这种情况是不润许的。

请问这是怎么回事？谢谢

[yu5212]

我也想知道行云流水的错在哪里

[李向荣]

UPDATE shop_book
SET dingjia =
(select dingjia from shop_book1009
where shop_book1009.shuming = shop_book.shuming
)

[asp2006boy]

感谢“lxrxyls(行云流水) (”
但是还是报那个错误。

[myvicy]

UPDATE shop_book,shop_book1009
SET shop_book.dingjia = shop_book1009.dingjia
WHERE (shop_book.shuming = shop_book1009.shuming)

[asp2006boy]

首先感谢myvicy(看着远方，走脚下的路。) ，但是你的语句在第一行‘,’附近有语法错误。

[myvicy]

你在asp里是怎么写的，代码帖下看看。