GROUP BY gives an aggregation (summary) of the base data.
Example. Total sales by type (from the Pubs database):
SELECT type, SUM(ytd_sales)
GROUP BY type
If you have a specific problem, post DDL for your table(s), post some sample
data as INSERT statements and give an example of the result you are looking
Please reply only to the newsgroup