MySQL INNER JOIN Problem

Databases
1

I need this to return 1 result that matches 1111 that is in one of the usergroupid of 6, 9, 12, OR 13.
This returns all matches for the selected usergroupid’s?
Or should I be using a different JOIN method?

SELECT 
  userfield.userid,
  userfield.field5,
  user.userid,
  user.usergroupid
FROM
  userfield
  INNER JOIN user ON (userfield.userid = user.userid)
WHERE
  userfield.field5 = '[B]1111[/B]' AND 
  user.usergroupid = '[B]6[/B]' OR 
  user.usergroupid = '[B]9[/B]' OR 
  user.usergroupid = '[B]12[/B]' OR 
  user.usergroupid = '[B]13[/B]' 
[B]LIMIT 1[/B]
2 
WHERE
  userfield.field5 = '1111' [COLOR="Red"]AND [/COLOR]
  [COLOR="Red"][B]([/B][/COLOR] user.usergroupid = '6' OR 
  user.usergroupid = '9' OR 
  user.usergroupid = '12' OR 
  user.usergroupid = '13' [COLOR="red"][B])[/B][/COLOR]

see the parentheses? they ensure that the 1111 goes together with all of those OR conditions, and not just the first one only

alternatively…

WHERE
  userfield.field5 = '1111' AND 
  user.usergroupid IN ( '6','9','12','13' )
3

ohh yes, Perfect,

Thank you r937