I have five tables that are connected with each other using joins:
course— one to many
classes— one to many
section— many to many
I want to retrieve the sections the belong to a particular course. I have tried inner join to achieve this but I can not get good results, I get all the sections instead.
select sectionname from Section inner join Classes on classid=sectionid inner join Course on courseid=Classes.fk_course_courseid;
Data contained in the table as shown below. I want to retrieve all the sections the belong to
courseid = 1 or
department id = 1.