BR><BR>Is there a way to use aggregate functions and only group on specific keys, rather than every column? For instance, I have the following query a lot.<BR><BR>Select (lots of junk), Count ...

This SQL feature allows you to query within ... ensuring that you do not have a match. Use aggregate functions for comparison In addition to using subselects to examine data in related tables ...