afrausto
Posts: 66
|
| Posted: 05/08/2006, 10:18 PM |
|
Hello Can anyone tell how to accomplish the following for a grid. I'm trying to display the results from two tables. Table A contains records of contestants. Table B contains the judges scores of contestants. The judges have been delegated certain groups to judge, all contestants are score by one judge only. I want to display all of the records in Table A for this year's contestants and include any scores entered by judges so far.
This is what I have so far:
SELECT ContestantName, JudgeScore
FROM tblContestants LEFT JOIN tblJudgesReview ON
tblContestants.PID = tblJudgesReview .PID
WHERE tblContestants.Year_of_Contest = '2006'
AND tblContestants.ApplicationComplete = {True}
AND tblJudgesReview.TypeOfReviewer = '{40}'
ORDER BY ContestantName
I'm not getting the expected results, because if a contestant does not have a score from a judge in tblJudgesReview then the record is not displayed. I want to show all records from tblContestants regardless if they have been given a score by their assigned judge.
I'm using CCS/ASP/MsAccess
Thanks,
Albert
|
 |
 |
|
