Sample Header Ad - 728x90

How do I get the some of the values from 2 foreign keys in a table?

0 votes
1 answer
20 views
I've spent a good amount of time on this but, still have no idea as to the sql query I can use to get the student name, and class name from the payments_per_student table. edit: This using JPA work with this DB. Knowing the JPA way as well SQl way would be interesting. I'm currently researching the JPA way. payments_per_student: PAYMENTS_PER_STU_ID STUDENTS_STUDENT_ID FAMILY_ACCOUNT_FAMILY_ID REASON_FOR_PAYMENT AMOUNT DATE_PAID CLASSES_CLASS_ID ACTIVE_IN_CLASS NOTES The second is, Classes: CLASS_ID CLASS_NAME DAY_OF_CLASS TIME_OF_CLASS DURATION_OF_CLASS PRICE_PER_CLASS PRICE_PER_TERM PRICE_PER_YEAR NOTES The third table is, Students: STUDENT_ID FIRST_NAME LAST_NAME FAMILY_ACCOUNT_ID SEX_TYPE NAME_PREF DATE_OF_BIRTH PERFORMANCE_STU HEALTH_ISSUES NOTES
Asked by user465001 (115 rep)
May 19, 2015, 09:16 PM
Last activity: May 19, 2015, 10:08 PM