Count CustomersOrders

Assuming you have the CustomerID in the Orders table as a foreign key back to the Customers table, you can do a group by on the Orders.CustomerID and do a count. Using the Northwind database schema: select CustomerID, count(OrderID)from Ordersgroup by CustomerID This will only give you results for the customers that have orders. If you need the customers without orders as well, you will need to include the Customers table. For example with a left outer join: select C.CustomerID, count(O.OrderID)from Customers C left outer join Orders O on C.CustomerID=O.CustomerIDgroup by C.CustomerID Best regards Michael <Hassano@.discussions.microsoft.com> wrote in message news:d8b7a568-55d1-4bf8-a2f3-3a5635706ab4@.discussions.microsoft.com...Dear Team if there are three tables customers, Order and OrderDetails how to count the number of orders for each certain customer Thank you very muchDear Team
if there are three tables customers, Order and OrderDetails
how to count the number of orders for each certain customer

Thank you very much|||Mr NNTP
The Query looks good thank you very much
i will take some time to test it