Posted by Dave on 10/05/46 11:16

Geoff Berrow (blthecat@ckdog.co.uk) decided we needed to hear...
> >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)
>
> Can you do that in MySQL now?
>
IIRC sub-selects came in at v4.1

--
Dave <dave@REMOVEbundook.com>
(Remove REMOVE for email address)

[Back to original message]