or maybe it's me :) Anyway here is my table
+------------+--------------+ | RecordID | School | | PID,AI,INT | Varchar | +------------+--------------+ | 108 | Columbia | +------------|--------------+ | 108 | Princeton | +------------|--------------+ | 108 | Stamford | +------------|--------------+ | 109 | USC | +------------|--------------+ | 109 | NYU | +------------|--------------+ | 109 | Columbia | +------------|--------------+ If I do this: SELECT School,RecordID FROM Profiles_Schools WHERE School = Columbia I get back RecordID's 108 and 109 But if in the where statment I add: where School = Columbia and School = Stamford Nothing is returned Am I doing something wrong. btw I have comp indexes on both columns. Thank you , Stuart -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]