Posted by Dave on 11/11/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)

• Next in forum: Re: strange behavior with phpmyadmin and innodb tables
• Prev in forum: Re: Hopefully flattery will get me everywhere... ;0)
• Thread view: Re: PHP MySQL question

[Reply to this message]