I have three tables:
- question
(qId,qTitle)
- student
(studentId,studentName)
- marks
(studentId,qTitle,qMark)
I want to do is:
when a teacher is logged in then he is able to see all the record combining above three tables.
If student do any question then its entry store in marks table.
I want to join all three tables so that all qTitle will come with studentName and its qMark.
If question table contains 3 question and particular student attended only one question then also in result I want to see all the question title whether student attend it or not.
Can anybody give me the SQL query to do this.