Andrew R Posted March 26, 2010 Share Posted March 26, 2010 Hi there I have the following two tables: Users(UserID,name); Awards(AwardID,UserID,AwardName); What I'm trying to do is select all the users who haven't got an award yet so I can print them out in a table. I have created the following query with no luck. SELECT * FROM (`Awards`) JOIN `Users` ON `Awards`.`UserID` = `Users`.`UserID` Thanks a million. Link to comment https://forums.phpfreaks.com/topic/196599-join-help/ Share on other sites More sharing options...
DavidAM Posted March 26, 2010 Share Posted March 26, 2010 That should get you all the users that HAVE received awards. To get the ones that have NOT, you have to do an outer join and look for a NULL award. Something like this: SELECT * FROM Users LEFT JOIN Awards ON Users.UserID = Awards.UserID WHERE Awards.AwardID IS NULL Link to comment https://forums.phpfreaks.com/topic/196599-join-help/#findComment-1032245 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.