select t1.USER_DISPLAY_NAME
from ubbt_USERS as t1,
ubbt_USER_GROUPS as t2
where t2.GROUP_ID='6'
and t1.USER_ID = t2.USER_ID
Change 6 to whatever group number you want.
Spot on! Exactly what I was looking for. Thanks.
I know absolutely nothing about SQL queries.
