Gesch=E4ftsf=FChrer: Dr. Bernd Reifenh=E4user, Dr. Alexander Ebbes Handelsregister: HRB 6870 - Amtsgericht Mainz
-----Urspr=FCngliche Nachricht----- Von: Olivier Nicole [mailto:Olivier.Nicole@cs.ait.ac.th] Gesendet: Mittwoch, 29. April 2015 07:21 An: mogens@fumlersoft.dk Cc: mysql@lists.mysql.com Betreff: 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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Apr 29
Olivier Nicole Re: AW: Select one valuebut not the other
Apr 29, 2015; 17:16
Olivier Nicole
Re: AW: Select one valuebut not the other
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!