November 11th, 2011, 11:51 AM
|
|
Registered User
|
|
Join Date: Nov 2011
Posts: 1
Time spent in forums: 1 h 17 m 45 sec
Reputation Power: 0
|
|
|
Help with Query - Need Distinct Names
I have this query:
Code:
SELECT projects.id, projects.proj_name, items.item, items.date_entered, users.first_name, users.last_name, users.Active
FROM ([SELECT users_project.proj_id
FROM users_project
WHERE (users_project.users_id=1)]. AS x INNER JOIN projects ON x.proj_id = projects.id) INNER JOIN (users INNER JOIN items ON users.id = items.users_id) ON projects.id = items.projects_id
GROUP BY projects.id, projects.proj_name, items.item, items.date_entered, users.first_name, users.last_name, users.Active
HAVING (((items.date_entered) Not Between (Date()-Weekday(Date())+1) And (Date()-Weekday(Date())+7)))
ORDER BY users.last_name;
It gives me this result:
Project 1 This is item 1 proj1 11/4/2011 Tom Jones
Project 1 This is item 2 proj 1 11/4/2011 Tom Jones
Project 2 This is item 4 proj 2 11/5/2011 Tom Jones
Project 3 This is item 7 proj 3 11/4/2011 Tom Jones
Project 1 This is item 6 proj 1 11/5/2011 Harry Smith
I just need a row per each person, so in this case just two rows. How do I modify the query to do this? Any help is appreciated. THanks
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
