Jump to content

select unique


jeff5656

Recommended Posts

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?  :-)

Link to comment
https://forums.phpfreaks.com/topic/241826-select-unique/
Share on other sites

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
)

Link to comment
https://forums.phpfreaks.com/topic/241826-select-unique/#findComment-1241927
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.