这段sql代码什么意思?解决办法
这段sql代码什么意思?
谁最好可以用中文翻译一下哦
------解决方案--------------------
简单整理一下,就是如下意思
insert into A表 select * from B表
将B表的数据插入A表,这里的B表可能是一个复杂的查询语句
- SQL code
INSERT INTO ProductCode (ProductID, SupplierID, ProductCode, ConvertRate) SELECT PorderImport.MEDICAL_CODE, PorderImport.SALER_CODE, PorderImport.MEDICAL_CODE AS Expr2, 1 AS Expr1 FROM 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_CODE WHERE (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表可能是一个复杂的查询语句