Am I missing something?
Will this not do the trick:
SELECT DISTINCT member_id FROM table WHERE specialty_id IN(6,33);
That would return any member_id with specialty_id=6 and any member_id with specialty_id=33, i.e. member_ids with specialty_id 6 OR 33. I think he wanted member_ids with specialty_id 6 AND 33.
-- Roger
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
