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
Apr 29
Mogens Melander Re: Select one valuebut not the other
Apr 29, 2015; 07:08
Mogens Melander
Re: Select one valuebut not the other
Apr 29
Olivier Nicole Re: Select one valuebut not the other
Apr 29, 2015; 12:20
Olivier Nicole
Re: Select one valuebut not the other
Apr 29
Mogens Melander Re: Select one valuebut not the other
Apr 29, 2015; 09:20
Mogens Melander
Re: Select one valuebut not the other
Apr 29
Lucio Chiappetti Re: Select one valuebut not the other
Apr 29, 2015; 11:27
Lucio Chiappetti
Re: Select one valuebut not the other
Apr 29
Olivier Nicole Re: Select one valuebut not the other
Apr 29, 2015; 17:08
Olivier Nicole
Re: Select one valuebut not the other
Apr 29
Olivier Nicole Re: Select one valuebut not the other
Apr 29, 2015; 17:15
Olivier Nicole
Re: 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!