Say I have three tables - pupils, classes and entries.
Table pupils: pupil_id (primary key) first_name middle_name last_name email (unique) password reg_date Table classes: class_id subject_name level_of_entry exam_board Table entries: entry_id (primary key) exam_date class_id (foreign key) pupil_id (foreign key)
Now, for example, let me say that a pupil with the name of Jonathan Parker Smith (pupil_id = 1) was taking a Chemistry exam (class_id = 3) which was 'A2' level_of_entry and part of the 'WJEC' exam board. The entry_id would be 5 and let us say that the exam was to be taken on the 25/06/18. There are other pupils like Jonathan who are taking exams in the 'WJEC' board but with other subjects. How would I create a query script (MySQL) that looks at the 'entries' table and lists the names of all pupils, class name and level of entry for the exams entered with the 'WJEC' exam board? I have done some research and that has led me to believe that I should use a SELECT command...
Any help appreciated, Thanks.