Re: Select one valuebut not the other
> 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
Re: Select one valuebut not the other
SELECT * FROM table WHERE item_number=1; 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
Select one valuebut not the other
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 -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql