How do I get the some of the values from 2 foreign keys in a table?
This is a good start:

select S.FIRST_NAME,    C.CLASS_NAME,    C.DURATION_OF_CLASS
FROM STUDENTS S
INNER JOIN PAYMENTS_PER_STUDENT A ON S.STUDENT_ID=PAYMENTS_PER_STU_ID
INNER JOIN CLASSES_R C ON A .CLASSES_CLASS_ID = C.CLASS_ID;


I found it + here.