用表tt更新表products

UPDATE products
SET FactoryNoEx = tt.FactoryNoEx
FROM products JOIN
      tt ON products.productID = tt.productID
posted @ 2011-05-15 18:13  S E N Y I  阅读(154)  评论(0)    收藏  举报