JOINs

[stevenblanc]

Hi folks,

So I'm trying to combine data from 4 tables, but to start im just trying to make sure my joins are set up properly. The idea is to have all the rows from the first table regardless of whether data is present on the other tables and join the other tables where there is data.

So:

SELECT 
tblCourseRecords.CourseRecordID, tblCourseRecords.semesterID, tblCourseRecords.departmentID, tblCourseRecords.courseID, tblCourseRecords.sectionID, tblCourseRecords.facultyID, tblCourseRecords.dateEntry, tblCourseRecords.dateModify, tblCourseRecords.numEnrollment, tblCourseRecordPedMarking.pedTime

FROM ((((

tblCourseRecordPedTutorials 

LEFT OUTER JOIN tblCourseRecords ON tblCourseRecordPedTutorials.CourseRecordID = tblCourseRecords.CourseRecordID) 

LEFT OUTER JOIN tblCourseRecordPedAdmin ON tblCourseRecords.CourseRecordID = tblCourseRecordPedAdmin.CourseRecordID) 

LEFT OUTER JOIN tblCourseRecordPedMarking ON tblCourseRecords.CourseRecordID = tblCourseRecordPedMarking.CourseRecordID) 

LEFT OUTER JOIN tblCourseRecordPedLabs ON tblCourseRecords.CourseRecordID = tblCourseRecordPedLabs.CourseRecordID) 

LEFT OUTER JOIN tblCourseRecordPedOther ON tblCourseRecords.CourseRecordID = tblCourseRecordPedOther.CourseRecordID;

Result is nada, where Im hoping to at least see the data for the first table, tblCourseRecords. I'm assuming its a join problem. Should I only have one left outer join and a series of full joins?

 

[boblarson]

Get rid of the word OUTER on each of those as it should say LEFT JOIN. Also, you will need parentheses and I hate trying to figure out where they go so I use the QBE (query by example) grid.