SQL两个表，一个带附加功能的结果

I have two tables. The first Holds a list of classes with basically an ClassID and a ClassName. The second Holds a list of classes that a pupil does attend using ClassID and PupilID (PupilID refers to a third table).I have two tables. The first Holds a list of cl