Hi ya'll! I have a little problem with a query, no actually not o little problem but a big one. I haven't got o clue how to write it. This is what I want: This is the table id | drink_id | ing_id | vol_id ------------------------------- 1 | 10 | 1 | 5 2 | 10 | 5 | 1 3 | 10 | 2 | 3 4 | 11 | 5 | 6 5 | 11 | 3 | 23 5 | 11 | 9 | 57 6 | 12 | 34 | 11 7 | 12 | 21 | 9 8 | 12 | 32 | 34 9 | 13 | 89 | 3 10 | 13 | 76 | 7 11 | 13 | 23 | 54 12 | 13 | 7 | 10 13 | 14 | 5 | 22 14 | 14 | 1 | 34 15 | 15 | 39 | 21 16 | 15 | 27 | 2 17 | 15 | 50 | 5 18 | 16 | 3 | 45 19 | 16 | 5 | 35 If a person enters that he has the following ing_id 1, 2, 3, 5 I whant to get the drink_id wich has 1, 2, 3 OR 5 but NOTHING else. So if I would run this query I would get the following drink_id: 10 because it has ing_id 1,5,2 14 because it has ing_id 5,1 16 because it has ing_id 3,5 NOT 11 because it has ing_id 5,3 AND 9 and there is not a 9 in the list. Someone? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
