I am trying select all the class names from tbl_class_Names that are not listed in
I have tried this select statement however it does not work..
join tbl_Class on tbl_Class.Class_ID = tbl_Students.Class_ID
join tbl_Class_Names on tbl_Class_Names.CN_ID = tbl_Class.CN_ID
where tbl_Students.Class_ID <> tbl_Class on tbl_Class.Class_ID
I have inherited the database so the structure is not ideal.
Student_Number Class_ID Lecture_Room
511 18 5
512 15 9