Ansel_Tk1 Posted July 21, 2008 Share Posted July 21, 2008 Hi - can someone point me in the right direction? My SQL statement: SELECT DISTINCT onlinetotal.FamilyID FROM onlinetotal JOIN login ON onlinetotal.FamilyID = login.family_id WHERE recupdated = 1 ORDER BY onlinetotal.FamilyID I get 1 record as expected, but I don't get any of the values in the fields of the table login. There is a field in the login table that I specifically want: login.email_usr Basically, For each unique family_id value, I want the corresponding email_user value in the login table, using family_id as the key. Thanks for any help. Dan Link to comment https://forums.phpfreaks.com/topic/115756-solved-using-distinct-and-join/ Share on other sites More sharing options...
Zwiter Posted July 21, 2008 Share Posted July 21, 2008 You have to write the attribute list you want to get in the select. Leave the dinstinct in front of the attribute you want unique. But i suggest to use a group by. Z. Link to comment https://forums.phpfreaks.com/topic/115756-solved-using-distinct-and-join/#findComment-595131 Share on other sites More sharing options...
Ansel_Tk1 Posted July 21, 2008 Author Share Posted July 21, 2008 Thanks Zwiter! Appreciate your help! Link to comment https://forums.phpfreaks.com/topic/115756-solved-using-distinct-and-join/#findComment-595461 Share on other sites More sharing options...
tivrfoa Posted July 21, 2008 Share Posted July 21, 2008 Just to correct the use of distinct. Distinct is used when you don't want to show equals rows, so you have unique rows, it's not used for attributes, and you must use distinct soon after the select. Link to comment https://forums.phpfreaks.com/topic/115756-solved-using-distinct-and-join/#findComment-595470 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.