I have a table for user labels it contains the user_id, the group_id, and the status.
I am building a search page that will allow the admins to find users who belong to a label and also another label (or NOT) another label.
I understand obviously how to select * where group_id='#' but how do I make sure that the user_id for the returned row also belongs to the 2nd selected user group (or doesn't belong for that matter)?
Bookmarks