Query Not returning all Reccords

[lindseyaileen]

I have been hunting trying to find the solution an I have tracked down the problem to be with the joins in my query but it keeps returning syntax errors when I try to change it. I need the table classes to be the main table for the query. I need to see all of those records and I just want the added information from Instructors and Locations when they are available.

here is my code

 SELECT Classes.CourseTitle, Classes.[YourU Description], Instructors.FirstName, Instructors.LastName, 
Classes.HoursOfInstruction, 
Classes.StartDate, Classes.EndDate, Classes.Sessions, Classes.StartTime, Classes.EndTime, Classes.ClassFee,
 Classes.Category.Value, 
Classes.[Course Type].Value, Classes.CourseDescription, Classes.NoDiscount,
 Locations.OffSite, Locations.LocationName,
 Locations.LocationAddress, Locations.City, Locations.Phone
FROM Locations INNER JOIN (Instructors INNER JOIN Classes 
ON Instructors.InstructorID = Classes.[Instructor ID]) 
ON (Locations.LocationID = Classes.LocationID) AND (Locations.LocationID = Classes.LocationID)

WHERE (((Classes.Status)="Run") AND ((Classes.Semester)=[Forms]![Main Menu]![TextSemester]));

Any help would be much appreciated.

 

[krausr79]

List your 'always' data first in the FROM statement, then do left join instead of inner join on the optional tables.