nick轩

导航

SQL 多表联合更新

1、update a set a.p2=b.p2,a.bztks=b.bztks from Product a,price b where a.hpbm=b.hpbm
2、update Product set Product.p2=price.p2 From Product,price WHERE Product.hpbm=price.hpbm

posted on 2010-11-23 17:46  nick轩  阅读(357)  评论(0编辑  收藏  举报