jeff5656 Posted July 12, 2011 Share Posted July 12, 2011 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 More sharing options...
requinix Posted July 12, 2011 Share Posted July 12, 2011 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 More sharing options...
ebmigue Posted July 13, 2011 Share Posted July 13, 2011 $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. Link to comment https://forums.phpfreaks.com/topic/241826-select-unique/#findComment-1242274 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.