update语句是很耗时的,你可以这样.1.将有用的数据先存入到一个临时表.select shop_snsn.*(这里把shop_snsn.kucun,替换成bt.kucun) into #shop_snsn_temp from shop_snsn, bt where bt.isbn = shop_snsn.cjname and shop_snsn.shopclass=2删除shop_snsn表中的数据delete from shop_snsnwhere exists (select 'x' from bt where bt.isbn = shop_snsn.cjname) and shop_snsn.shopclass=2将#shop_snsn_temp表中的数据插回到shop_snsn表中.insert into shop_snsn select * from #shop_snsn_temp删除临时表drop table #shop_snsn_temp