Say I have two tables:
tblCustomer and tblPurchases
a single customer can purchase many items from the store.
If I do a regular query, the customer's name is repeated for each purchase made.
Instead I would like a TOTAL of all their purchases (Quantity) for each customer.
So a list of all the customers, and the total amount each customer has purchased.