I am trying to join the table STUDENT to STUDY_PROGRAM. STUDENT to STUDY_PROGRAM is a one to many relationship. The query on a simple natural join didn't give the expected result. Debugging shows that the query result didn't have 'program' columns.I am trying to join the table STUDENT to STUDY_