June 13, 2013 at 9:11 am
I would like to select distinct values from 1 column in my query.
If I was selecting just 1 column in a simple query it would probably work, but I've got a more complex query and having trouble with it.
here is my code:
SELECT db.myTable.myFieldId, db.myFields.ModuleId, db.myTable.FieldValue
FROM db.myTable INNER JOIN
db.myFields ON db.myTable.myFieldId = db.myFields.myFieldId INNER JOIN
db.myRows ON db.myTable.myRowId = db.myRows.myRowId
WHERE (db.myFields.ModuleId = 1397) AND (db.myTable.myFieldId = 221)
The part I want to be distinct is this bit: db.myTable.FieldValue
If I insert the word 'distinct' before it, an error returns saying I can't do this.
thanks,
mark.
June 13, 2013 at 9:16 am
It's easy, but you need to define which value of db.myTable.FieldValue do you want when multiple values are available.
June 13, 2013 at 9:28 am
mrichardson 57577 (6/13/2013)
I would like to select distinct values from 1 column in my query.If I was selecting just 1 column in a simple query it would probably work, but I've got a more complex query and having trouble with it.
here is my code:
SELECT db.myTable.myFieldId, db.myFields.ModuleId, db.myTable.FieldValue
FROM db.myTable INNER JOIN
db.myFields ON db.myTable.myFieldId = db.myFields.myFieldId INNER JOIN
db.myRows ON db.myTable.myRowId = db.myRows.myRowId
WHERE (db.myFields.ModuleId = 1397) AND (db.myTable.myFieldId = 221)
The part I want to be distinct is this bit: db.myTable.FieldValue
If I insert the word 'distinct' before it, an error returns saying I can't do this.
thanks,
mark.
If your base data was like this:
(myFieldId, ModuleId, FieldValue)
(1,2,1)
(3,4,1)
and you want 'FieldValue' to be distinct, which version of myFieldId and moduleId would you want to display?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy