How can fix the the problem of null value in a query ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

SELECT CountJudge.Year, CountJudge.Quarter, CountJudge.ID, CountJudge.Name,
CountJudge.[Task#], CountJudge.StartDate, CountJudge.EndDate,
CountJudge.Duration, CountJudge.Judge, CountNotJudge.NotJudge,
CountMale.Male, CountFemale.Female,
Count_All_Participants.All_Participants_Day
FROM ((CountMale RIGHT JOIN CountFemale ON CountMale.ID=CountFemale.ID)
RIGHT JOIN (CountNotJudge RIGHT JOIN CountJudge ON
CountNotJudge.ID=CountJudge.ID) ON CountFemale.ID=CountNotJudge.ID) RIGHT
JOIN Count_All_Participants ON CountJudge.ID=Count_All_Participants.ID;
 
Hamada said:
SELECT CountJudge.Year, CountJudge.Quarter, CountJudge.ID, CountJudge.Name,
CountJudge.[Task#], CountJudge.StartDate, CountJudge.EndDate,
CountJudge.Duration, CountJudge.Judge, CountNotJudge.NotJudge,
CountMale.Male, CountFemale.Female,
Count_All_Participants.All_Participants_Day
FROM ((CountMale RIGHT JOIN CountFemale ON CountMale.ID=CountFemale.ID)
RIGHT JOIN (CountNotJudge RIGHT JOIN CountJudge ON
CountNotJudge.ID=CountJudge.ID) ON CountFemale.ID=CountNotJudge.ID) RIGHT
JOIN Count_All_Participants ON CountJudge.ID=Count_All_Participants.ID;
Click to expand...

You could begin by explaining what the problem is...
 
Are you sure that you need multiple RIGHT JOIN(s) instead of INNER JOIN(s)?
This is the first time that I see so many RIGHT JOIN(s) in the same Select
statement.

S. L.
 
Back
Top