Why does this query return 0 results? (picture) (1 Viewer)

[Zak14]

Is it supposed to do this? Am I doing something wrong?
Picture attached. Thanks.

 

[JHB]

Maybe any corresponding data?

 

[vbaInet]

It's a simple matter of your joins. Change all three joins to include all data from tbl_Classes.

 

[plog]

INNER JOINS act as criteria, you must have data in both sides of the join for anything to be returned. That means you one or more of your links don't have matching data between them.

So, one or more of the following is true:

1. tbl_Classes.CourseID has no values in tbl_Courses
2. tbl_Classes.TrainingCenreID has no values in tbl_TrainingCentres
3. tbl_Classes.TeacherID has no values in tbl_Teachers

If you think there should be results, show data from all your tables which you believe will produce these results.

 

[Zak14]

Thanks guys. I've been trying to figure this one out all day; I should've known.
I'm not inputting any data atm so I made the join a type 3 so all data from tbl_Classes is displayed.