select top 20 field1, COUNT(field1) AS Expr1, (SELECT whatever FROM
something WHERE blah...) as TheNewField
FROM ...
If your DB supports it, this means the text-type column doesn't have to be
grouped.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]