ordersandtotalspercustomer.sql

来自「Mastering VBNet Include Source Code」· SQL 代码 · 共 10 行

SELECT     Customers.CompanyName, COUNT(Orders.OrderID) AS [Total Orders], 
           Customers.CustomerID, SUM([Order Details].Quantity * Products.UnitPrice) 
           AS Total
FROM       Customers INNER JOIN
           Orders ON Customers.CustomerID = Orders.CustomerID INNER JOIN
           [Order Details] ON Orders.OrderID = [Order Details].OrderID INNER JOIN
           Products ON [Order Details].ProductID = Products.ProductID
GROUP BY   Customers.CompanyName, Customers.CustomerID
HAVING     (Customers.CustomerID = @CustomerID)