>I need to count the number of orders by customer in a table. I'm sure that it can be done using SQL, but I can't quite figure it out.
>
>The table has multiple orders for multiple customers.
>
>Can someone give me a starting point for this situation?
>
>Thanks,
>
>Harry
SELECT custnum, COUNT(*) FROM orders GROUP BY custnum
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers