How do I do this

Hello. I have a table of exams, a table of pupils and a table of what exams the pupils are doing. How do I group them in the table of what exams each pupil is doing into exam boards when the exam board is not in that table (it is in the subject id part which links to the exams)

Have a look at the SQL term INNER JOIN - as long as you can specify a common field (in this case, the subject id) you can retrieve the exam board at the same time as retrieving the exam.

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.