perty simple query.
bleh it's 1am and i just got back from hospital visiting a friend (all is well after his getting 2 knees replaced).
if no one posts here with the sql, i can whip it up in the morn. i'm just a tad hazy right now with all that was going on...
it's basically an IN (xx) and not IN (aa, bb, cc) kinda query
quickie of top of head is
SELECT ug.USER_ID, u.USER_DISPLAY_NAME
FROM
ubbt_USER_GROUPS as ug
INNER JOIN ubbt_USERS as u ON (ubbt_USER_GROUPS.USER_ID=ubbt_USERS.USER_ID)
WHERE ug.GROUP_ID IN (3) and ug.GROUP_ID NOT IN(6,7,8)
assumes 3 is user group
assumes 6,7,8 are your 'special' groups
returns users who are 'users', but not in the 3 special groups.
i'll recheck syntax tomorrow..
good nite
you, 
Previous Topic
Index
