Total

  • Thread starter Thread starter JLS
  • Start date Start date
J

JLS

I was wondering if i have a table and in the first column
is the category which the product would fall under in the
second column is the names of product... How could I get a
total for the second column for each of the distinct
categorys in the first with out querying for each distinct
category name.

Category Name Product Type
Safety Eye Glasses
Safety Helmet
Chemicals Acids

I want the total products for each of the distinct
Catgoreis. Please Help!
 
Please be more specific. What are you trying to total - none of the fields
you have shown have numbers.

From the sample data you have given what result set are you expecting from
the query?
 
Back
Top