Jump to content

JOIN Help


Andrew R

Recommended Posts

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

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

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.