tags:

views:

24

answers:

0

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.