SQL 3.23 JOINs

CREATE TABLE `program_interests_programs` (  `id` int(11) NOT NULL auto_increment,  `program_interest_id` int(11) NOT NULL default '0',  `program_id` int(11) NOT NULL default '0',  PRIMARY KEY  (`id`),  KEY `program_interest_id` (`program_interest_id`,`program_id`))SELECT p1.program_interest_id FROM `program_interests_programs` p1 INNER JOIN `program_interests_programs` AS p2 on p1.id = p2.id AND p2.program_interest_id = 100 INNER JOIN `program_interests_programs` AS p3 on p1.id = p3.id AND p3.program_interest_id = 203