ABAP : MAX,MIN with name(JOIN)

TABLES : zpat_student,zpat_subject.
data : max_score type zpat_student-score,
      names type zpat_student-name,
      min_score type zpat_student-score.
*--------------find max,min score-------------------------
select max( score ) min( score ) into (max_score, min_score)
  from zpat_student.
  write : / 'NAME', 20 'SCORE', 40 'GRADE', 60 'SUBJECT'.
  uline .
*-------------find name matching with score---------------
  SELECT * from zpat_student where score = max_score or score = min_score.
*---------------Join table with ZPAT_STUDENT-------------
    SELECT * from zpat_subject where grade = zpat_student-grade.
    write : / zpat_student-name, 20 zpat_student-score, 40 zpat_subject-grade , 60 zpat_subject-subject.
    ENDSELECT.
  ENDSELECT.