Re: Select one valuebut not the other
- Date: Wed, 29 Apr 2015 09:20:10 +0200 (CEST)
- From: "Mogens Melander" <mogens@xxxxxxxxxxxxx>
- Subject: Re: Select one valuebut not the other
Take a look at this one then:
insert into test(item_number,data_value)
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);
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"
>> On Wed, April 29, 2015 06:30, Olivier Nicole wrote:
>>> 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
>>> 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,
+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