I have a table named Courses,CoursePreRequisites and a third tale named PreRequisiteTracking.One particular Course can contain multiple PreRequisites and so I couldn't pass a foreign key in the Courses tables and instead created the PreRequisiteTracking table.
Eg:A Course,say, Introduction to Java.This may have the following prerequsites:OOPS,Basic Programming Knowledge.
These prerequisites are given in checkboxes while creating a new course.
Now my problem is how do I join all these tables and list them in a View.
I joined all theses tables but since only Ids are being passed I am not able to retrieve the PreRequisites to show in the View.
Kindly help me,Thanks in advance