regarding inner join

[Former Member]

I am not getting how to inner join two tables(any two internal tables).

please give one example.

[Former Member]

Hi!

DATA: DATE   LIKE SFLIGHT-FLDATE, 
      CARRID LIKE SFLIGHT-CARRID, 
      CONNID LIKE SFLIGHT-CONNID. 
 
SELECT F~CARRID F~CONNID F~FLDATE 
    INTO (CARRID, CONNID, DATE) 
    FROM SFLIGHT AS F INNER JOIN SPFLI AS P 
           ON F~CARRID = P~CARRID AND 
              F~CONNID = P~CONNID 
    WHERE P~CITYFROM = 'FRANKFURT' 
      AND P~CITYTO   = 'NEW YORK' 
      AND F~FLDATE BETWEEN '19970910' AND '19970920' 
      AND F~SEATSOCC < F~SEATSMAX. 
  WRITE: / DATE, CARRID, CONNID. 
ENDSELECT.

Regards

Tamá

[Former Member]

Hi,

Check this,

data : begin of itab occurs 0,

matnr like mara-matnr,

ersda like mara-ersda,

maktx like makt-maktx,

end of itab.

SELECT A_{matnr A}ersda b~maktx

INTO itab

FROM mara AS A INNER JOIN makt AS b

ON A_{matnr = b}matnr

.

ENDSELECT.

Also read this link for understanding,

http://help.sap.com/saphelp_46c/helpdata/en/cf/21ec77446011d189700000e8322d00/frameset.htm

Regards

[varma_narayana]

Hi Srinivas..

You cannot join two internal tables.

but we can join two database tables and fetch the Data into internal table.

eg:

SELECT MARA_{MATNR MARA}MTART

MARC_{WERKS MARC}EKGRP

FROM MARA

INNER JOIN MARC

ON MARA_{MATNR = MARC}MATNR

INTO TABLE ITAB.

reward if Helpful