Question on MySQL SELECT

Hi everyone,

I have created a table with the following 3 columns

ID UserID SkillID
1 2 1
1 2 3
1 2 2
1 3 2

Is there a way to return all UserIDs that match SkillID=1 and SkillID=2 and
SkillID=3? (not OR)

Thank you
Maziar A.

Hi,

SELECT UserID, count(*) FROM t WHERE UserID >= 1 AND UserID <=3 GROUP
BY UserID HAVING count(*) = 3

This will return all user IDs that have 3 records of user ids between 1
and 3. The only reason is wouldn't work is if there were repeated rows
with the same userid and skillid.