Thanks Roger Works great! Can you explain the query if you have time! Thanks again Scott
-----Original Message----- From: Roger Baklund [mailto:roger@;charlott.no] Sent: 31 October 2002 10:46 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: A simple one that gets me! * scott > Hi gang > Need to get all items that are not in id supplied > > For example select * from test where id!=2 will do this but it will > also return values that are in 2 if they are also in another id!=2 In > my example if I used the above query I would get > 10,11,12,13,14,17,18,19,20,17,21,22,23 > > I would not want the 10 or the 17 (x2) as they are also in id2! Try something like this: select t1.* from test t1 left join test t2 on t2.id=2 and t2.item=t1.item where t2.id is NULL; -- Roger sql --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
