Posted by ECRIA Public Mail Buffer on 10/14/36 11:16

SELECT UserID FROM tablename WHERE UserID IN (SELECT UserID FROM tablename
WHERE SkillID=1) AND UserID IN (SELECT UserID FROM tablename WHERE
SkillID=2) AND UserID IN (SELECT UserID FROM tablename WHERE SkillID=3)

However, it may be more efficient for you to redesign your database.

ECRIA
http://www.ecria.com

• Next in forum: Re: HTTPS & PHP
• Prev in forum: Re: PHP MySQL question
• Thread view: Re: PHP MySQL question

[Reply to this message]