July 1, 2014 at 5:25 am
Hello
I have question, how to make it works:
I have table with four columns:
ID_PLACE
ID_ITEM
DATE
ID_USER
14301.01.2010100
14401.01.2010100
15501.01.2010100
16601.01.2010100
24301.01.2010100
24401.01.2010100
25501.01.2010100
26601.01.2010100
34301.01.2010100
34401.01.2010100
35501.01.2010100
36601.01.2010100
44301.01.2010200
44401.01.2010200
45501.01.2010200
46601.01.2010200
54301.01.2010100
54401.01.2010100
55501.01.2010100
56601.01.2010100
I need get information of ID_ITEMS assigned to each ID_USER, without worrying about ID_PLACE. Such like this:
ID_ITEM DATAID_USER
4301.01.2010100
4401.01.2010100
5501.01.2010100
6601.01.2010100
4301.01.2010200
4401.01.2010200
5501.01.2010200
6601.01.2010200
I cannot DISTINCT ID_PLACE, because it will cut off much more than needed.
Can someone help me? 🙂
July 1, 2014 at 5:33 am
Have you tried
SELECT DISTINCT ID_ITEM, DATE, ID_USER
?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply