Skip to Content
avatar image
-6
Former Member

what is abap inner join syntax?

inner join syntax in abap ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 23, 2017 at 09:40 AM

    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 ).
    Add comment
    10|10000 characters needed characters exceeded