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谁最好可以用中文翻译一下哦
(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谁最好可以用中文翻译一下哦
--就是查询出一个结果集 插入到ProductCode表中的 (ProductID, SupplierID, ProductCode, ConvertRate)---这几个字段中
--楼主可以单独执行SELECT 语句 就是要插入的结果 后面的得看写SQL的业务逻辑了
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
这种AS是什么意思,我们大学里没教过这样写的额。
s = @" SELECT TOP 1 Product.ProductID+Product.ProductName
FROM PorderImport INNER JOIN
Product ON PorderImport.MEDICAL_CODE = Product.ProductID
where discontinued='true' ";
额,我只学过insert into XXXXX values XXXXX
这样的
insert into A表 select * from B表
将B表的数据插入A表,这里的B表可能是一个复杂的查询语句