I'm trying to list all the users from various user groups. I can't figure out the SQL to get the list. My best attempt so far is this:
What's the right way to do this? Is there any easy alternative (using inbuilt function)?
SELECT * from xf_user WHERE user_group_id IN (3,4,5,6);