SQL Server中Insert與Select的組合使用

SQL Server中有示例數據庫Northwind。新建表Sales用于存儲銷售信息，字段為EmployeeID,ProductID,SupplierID,CustomerID,OrderDate,UnitPrice,Total,Quantity,Discount。

下面的語句從Orders,Order Details, Employees,Products, Suppliers, Customers表選擇相應的

數據插入Sales表：

insert into Sales(EmployeeID,ProductID,SupplierID,CustomerID,OrderDate,UnitPrice,Total,Quantity,Discount) select e.EmployeeID, p.ProductID, s.SupplierID,c.CustomerID, o.OrderDate, od.UnitPrice,od.Quantity*od.UnitPrice*(1.0-od.Discount)Total,Od.Quantity, od.Discountfrom Orders o,[Order Details] od, Employees e,Products p, Suppliers s, Customers cwhere (o.OrderID = od.OrderID) and(o.EmployeeID = e.EmployeeID) and(o.CustomerID = c.CustomerID) and(od.ProductId = p.ProductID) and(p.SupplierID = s.SupplierID);go