Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- TABLES: ZPAT_STUDENT,ZPAT_SUBJECT.
- DATA it_student type zpat_student OCCURS 0 WITH HEADER LINE.
- DATA: st_name type zpat_student-name,
- st_grade type zpat_student-grade,
- st_subject type zpat_subject-subject.
- write: 'name',20 'grade',30 'subject'.
- SELECT a~name a~grade b~subject
- into (st_name, st_grade, st_subject)
- from ZPAT_STUDENT as a INNER JOIN zpat_subject as b
- on a~grade = b~grade.
- WRITE: / st_name, 20 st_grade, 30 st_subject.
- ENDSELECT.
Advertisement
Add Comment
Please, Sign In to add comment