REPORT  Z04_021.

DATA: BEGIN OF wa,

                     carrid TYPE spfli-carrid,

                     connid TYPE spfli-connid,

                     fldate TYPE sflight-fldate,

           END OF wa,

           itab LIKE standard TABLE OF wa.

SELECT  a~carrid a~connid b~fldate

           INTO  CORRESPONDING FIELDS OF TABLE itab

           FROM   ( spfli AS p

                     INNER JOIN sflight AS f ON a~carrid = b~carrid AND

                                                                a~connid = b~connid    )

           WHERE b~seatsmax > b~seatsocc.

WRITE : ‘—INNER JOIN 결과—‘.

LOOP AT itab INTO wa.

           WRITE: / wa-carrid, wa-connid, wa-fldate.

ENDLOOP.