what is abap inner join syntax?

[former_member532563]

inner join syntax in abap ?

[Former Member]

See the ABAP documentation

[umayaraj]

see that DEMO_JOINS sample progarm.

first check abap doc (f1 press) before post question

[former_member502808 · Accepted solution]

Please see the ABAP documentation in your system. (You can ommit the INNER keyword, as INNER joins are the default)

SELECT scarr~carrid, scarr~carrname,
       spfli~connid
  FROM scarr
    INNER JOIN spfli ON scarr~carrid   EQ spfli~carrid
                    AND spfli~cityfrom EQ 'NEW YORK'
  INTO TABLE @DATA(lt_itab).

cl_demo_output=>display( lt_itab ).

[former_member532563 · Accepted solution]

Thank you