Thank you, > SELECT * FROM test > WHERE item_number in (SELECT item_number FROM test where data_value=1) > AND item_number not in (SELECT item_number FROM test where data_value = 2);
That did it. Olivier > On Wed, April 29, 2015 07:20, Olivier Nicole wrote: >>> SELECT * FROM table WHERE item_number=1; >> >> Sorry if my question was not clear: what I am looking for is: >> >> SELECT * FROM table WHERE data_value=1 AND "there is not any reccord with >> the same item_number and data_value=2" >> >> Olivier >> >>> >>> On Wed, April 29, 2015 06:30, Olivier Nicole wrote: >>>> Hi, >>>> >>>> I am sure that it is feasible with MySQl, and I am sure that's a newbie >>>> question, but my SQL skills are limited... >>>> >>>> I have a table where each record is made of one item_number and one >>>> data_value. >>>> >>>> If one item has several values, there are several records with the same >>>> item_number and a different data_value. >>>> >>>> What is the command to select all the records where an item_number has >>>> the data 1 but not the data 2? >>>> >>>> Thanks in advance, >>>> >>>> Olivier >>> > > -- > Mogens Melander > +66 8701 33224 > > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql