Hi,
Let's say I have a Customer table and an Order table. The latter is linked to the former through foreign key CustomerID. Now, I want to create a SQL statement which, given a CustomerID, returns the corresponding row in Customer table PLUS a field indicating the total number of orders this particular customer has. How can I achieve this with a single SQL statement?
Thanks in advance
--USE Northwind
SELECT Customers.CustomerID, SUM(Orders.OrderID) AS TotalOrders
FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID
GROUP BY Customers.CustomerID
|||Thanks, this is exactly what I want, except I need to change the aggregate function to Count instead of Sum.
No comments:
Post a Comment