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.Discount
                   from Orders o,[Order Details] od, Employees e,
                   Products p, Suppliers s, Customers c
                   where (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