首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > SQL Server >

这段sql代码什么意思?解决办法

2012-04-23 
这段sql代码什么意思?SQL codeINSERT INTO ProductCode(ProductID, SupplierID, ProductCode, ConvertRate

这段sql代码什么意思?

SQL code
INSERT INTO ProductCode                      (ProductID, SupplierID, ProductCode, ConvertRate)SELECT     PorderImport.MEDICAL_CODE, PorderImport.SALER_CODE, PorderImport.MEDICAL_CODE AS Expr2, 1 AS Expr1FROM         ProductCode AS ProductCode_1 RIGHT OUTER JOIN                      PorderImport INNER JOIN                      Supplier ON PorderImport.SALER_CODE = Supplier.SupplierID INNER JOIN                      Product ON PorderImport.MEDICAL_CODE = Product.ProductID ON ProductCode_1.ProductID = PorderImport.MEDICAL_CODE AND                       ProductCode_1.SupplierID = PorderImport.SALER_CODEWHERE     (ProductCode_1.ProductID IS NULL) AND (Supplier.Discontinued = 0) AND (Supplier.Status = N'2') AND (Supplier.EPS = 1)GROUP BY PorderImport.MEDICAL_CODE, PorderImport.SALER_CODE


谁最好可以用中文翻译一下哦


[解决办法]
简单整理一下,就是如下意思
insert into A表 select * from B表
将B表的数据插入A表,这里的B表可能是一个复杂的查询语句

热点排行