Re: Select one valuebut not the other
- Date: Wed, 29 Apr 2015 12:20:49 +0700
- From: Olivier Nicole <Olivier.Nicole@xxxxxxxxxxxx>
- Subject: 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"
> 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,
> 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