OK, I'm suffering a brain freeze. I want to list all of the users who are members of a particular group. Lets say the group name is teamone and ID for teamone is 12. What would my SQL look like to return a result of UserNames and User IDs (uids) that are members of teamone? Thanks in advance, John Hughes

John, you can try this: SELECT uid, username, grp_id, grp_name, grp_descr FROM gl_groups, gl_group_assignments, gl_users WHERE ug_main_grp_id = grp_id AND gl_users.uid = gl_group_assignments.ug_uid AND grp_id = 12

---

Geeklog components by PortalParts -- www.portalparts.com

Perfect. Thanks a whole lot. John Hughes