sql join

update Product set Companyid=Company.id from Company inner join Product on Company.CompanyMessage=Product.other1    

select * from  Company inner join Product on Company.CompanyMessage=Product.other1

select Product.id,Product.ProductName,Product.ProductType,Product.ProductTrademark,Product.ProductYield,Product.ProductNumber,Product.Productvalid,Company.id Companyid into aaa from  Company inner join Product on Company.CompanyMessage = Product.other1

大数据之两表关联 重新生成 删除旧表

sql join

原文：http://www.cnblogs.com/hellowzd/p/4283565.html