The original question was "show me the users who have ALL the values in the list but NOT MORE than the values in the list."
> -----Original Message----- > Bellow, Bambi > > Huh? I thought the question was, "give me all the usrs where > there exists a > record containing a 1,5, and 7". How can that return one > record, when there > are two users -- and only two users -- who have the 1,5,7 > combination? The > data provided shows that both GAP and GPA have a 1, 5 and 7 > and that no > other users do. My query provides that answer. If that wasn't the > question, then that won't be the answer; but if it *was* the > question, then > the query is correct. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).