Hi, I have three tables and I am trying to create a select statement whereby I can select all the student records from tbl_students and display the class_name that is stored in the tbl_class_names. The class_id and class name are stored in separate tables.
Student_Number Class_ID Lecture_Room
5 18 5
6 15 9
55 Science Y2
76 Math Y3
the result I am looking for would be this
Student_Number Class_Name Lecture_Room
5 Science Y2 5
6 Math Y3 9
I think I need some sort of join statement perhaps?