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
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