>I am trying to count on these records for a certain criteria though. For ex: I have a table with 41,000 records that contains serial numbers for products, and need to know the top 10 selling products for that day?? I know that top 10 will give me the top 10 but without a count on that serial number. I need to get it to count on those distinct serial numbers. Maybe you can not do this with a select statement Can You??
>
>Darren
Darren, add WHERE clause to SELECT-SQL.
Edward Pikman
Independent Consultant