On 8/17/07, Mark Joslyn <Mark.Joslyn at solimarsystems.com> wrote: > Is there a way to write the above query differently to achieve this? I would group by username, item also you can then go ahead and list 'item' in the select list -- Matt Warden Cincinnati, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy.