Allowing Nulls in queries

workingpoor

Registered User.
Local time
Yesterday, 19:44
Joined
Jul 19, 2006
Messages
21
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.
 
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
 

Users who are viewing this thread

Back
Top Bottom