JOIN Help

[Andrew R]

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.

[DavidAM]

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