REPORT Z04_022

REPORT  Z04_022.


DATA: BEGIN OF wa,


                     carrid   TYPE sflight-carrid,


                     connid   TYPE spfli-connid,


           END OF wa,


           itab LIKE SORTED TABLE OF wa


                                WITH NON-UNIQUE KEY carrid.


 


SELECT a~carrid b~connid


           INTO CORRESPONDING FIELDS OF TABLE itab


           FROM sflight AS a


                     LEFT OUTER JOIN spfli AS b ON a~carrid   =  b~carrid AND


                                                                          b~cityfrom = ‘OSAKA‘.


WRITE ‘OUTER JOIN 결과


LOOP AT itab INTO wa.


           WRITE: / wa-carrid, wa-connid.


ENDLOOP.


Leave a Reply