当前位置: 代码迷 >> Sql Server >> 这段sql代码什么意思?解决办法
  详细解决方案

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

热度:53   发布时间:2016-04-27 13:35:57.0
这段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表可能是一个复杂的查询语句
  相关解决方案