Allowing Nulls in queries

[workingpoor]

I am trying to build a report that will list all the classes that each student is taking. I also want this report to show if a student is not taking any classesby printing only their name and ID. I basically have 2 tables. One with student data and one with classes. It is a one to many relantionship. However, when i build the query it automatically omits the students that have nothing in the class table. How can i get around this or is there a better way to do it.

 

[Rich]

Change the joins around between the tables in your query

 

[workingpoor]

Can you be a little more specific right now i am jsut using a generic select statement

SELECT semester.semester, DSS_Student.StudentID, [LastName] & ", " & [FirstName] AS Name, Classes.CRN, [Dept] & "-" & [course] & "-" & [section] AS [Course #], [profFN] & " " & [ProfLN] AS Professor FROM semester INNER JOIN (Professor INNER JOIN (DSS_Student INNER JOIN Classes ON DSS_Student.StudentID=Classes.StudentID) ON Professor.profID=Classes.Professor) ON semester.semesterID=Classes.SemesterID

Sql statement are not my strong suit at all

 

[boblarson]

Use OUTER JOIN instead of INNER JOIN.

 

[workingpoor]

That worked perfectly!

Thanks