select unique

[jeff5656]

Ok I have this query:

 

$query = "SELECT *, u.lname as lastname, todo_patients.lname as todolname FROM todo_list 
inner join todo_patients  on (todo_list.pt_id = todo_patients.id )
INNER JOIN users u ON u.id = todo_patients.user_id"

 

how do I re do that so that only UNIQUE users are selected?  (from the users table with the alias of u)

Do I use "DISTINCT", and if so how do I put it into the above without causing a syntax error?  :-)

[requinix]

If you're SELECTing everything from all the tables then a DISTINCT doesn't make sense.

 

Do you only want a list of users who have todo items? I don't like DISTINCT so

SELECT * FROM users WHERE id IN (
SELECT tp.user_id FROM todo_patients tp
JOIN todo_list tl ON tp.id = tl.pt_id
)

[ebmigue]

$query = "SELECT DISTINCT u.* FROM todo_list 
inner join todo_patients  on (todo_list.pt_id = todo_patients.id )
INNER JOIN users u ON u.id = todo_patients.user_id"

 

Thay *may* work for you, too.