UPDATE user LEFT JOIN userfield ON (user.userid = userfield.userid) SET usergroupid = X WHERE field1 = 'man'