??? I'm not really sure that I understand the question -- it doesn't seem to make sense to me, but... what about something like this:<BR><BR><BR> SELECT COUNT( GamesPlayed ), SUM( GoalsScored ), TeamName<BR> FROM MyFavouriteSports<BR> GROUP BY TeamName<BR><BR>Is that what you mean? You want to perform an aggregate query, grouped by a single field??