JOIN문 실습

*&---------------------------------------------------------------------*
*& Report Z08WEEK_JOIN
*&---------------------------------------------------------------------*
*&
*&---------------------------------------------------------------------*
REPORT Z08WEEK_JOIN.

TYPES: BEGIN OF wa,
         carrid   TYPE scarr-carrid,
         carrname TYPE scarr-carrname,
         connid   TYPE spfli-connid,
         cityfrom TYPE spfli-cityfrom,
         cityto   TYPE spfli-cityto,
       END OF wa.

DATA itab TYPE TABLE OF wa.

SELECT c~carrid c~carrname p~connid p~cityfrom p~cityto
  FROM scarr AS c
  INNER JOIN spfli AS p
  ON c~carrid = p~carrid
  INTO TABLE itab.

cl_demo_output=>display( itab ).

• INNER JOIN 의 결과

  

*&---------------------------------------------------------------------*
*& Report Z08WEEK_JOIN
*&---------------------------------------------------------------------*
*&
*&---------------------------------------------------------------------*
REPORT Z08WEEK_JOIN.

TYPES: BEGIN OF wa,
         carrid   TYPE scarr-carrid,
         carrname TYPE scarr-carrname,
         connid   TYPE spfli-connid,
         cityfrom TYPE spfli-cityfrom,
         cityto   TYPE spfli-cityto,
       END OF wa.

DATA itab TYPE TABLE OF wa.

SELECT c~carrid c~carrname p~connid p~cityfrom p~cityto
  FROM scarr AS c
  LEFT OUTER JOIN spfli AS p
  ON c~carrid = p~carrid
  INTO TABLE itab.

cl_demo_output=>display( itab ).

• LEFT OUTER JOIN 의 결과

  

• RIGHT OUTER JOIN 을 사용하려고 하니 ,를 찍어야 한다고 나온다.

SELECT c~carrid, c~carrname, p~connid, p~cityfrom, p~cityto
  FROM scarr AS c
  RIGHT OUTER JOIN spfli AS p
  ON c~carrid = p~carrid
  INTO TABLE itab.

• ,를 찍으니 변수 앞에 @ 를 붙이라고 설명이 나온다.

SELECT c~carrid, c~carrname, p~connid, p~cityfrom, p~cityto
  FROM scarr AS c
  RIGHT OUTER JOIN spfli AS p
  ON c~carrid = p~carrid
  INTO TABLE @itab.

• RIGHT OUTER JOIN 결과물.
• RIGHT OUTER JOIN 은 신문법으로 사용 가능하다.
• SELECT 되는 것들에 , 를 찍고 변수 앞에 @ 를 붙여야 사용 가능하다. (하지만 INNER JOIN 과 결과가 같으니 INNER JOIN 을 쓰는게 나을 수도 있음.)