I'm having an issue with joining course_sections to course_modules.
Select * from mdl_course_sections cs where cs.course=10318; --- This returns 27 sections
Select * from mdl_course_modules cm where cm.course=10318; --- This only returns 3 sections
Why wouldn't all of the cs.id numbers exist in the course_modules table? From my research the join should be as follows:
Select * from mdl_course_sections cs
Join mdl_course_modules cm on cm.section=cs.id
What am I missing here?