topic Re: regarding inner join in Application Development and Automation Discussions

regarding inner join

Former Member — Mon, 10 Sep 2007 09:13:18 GMT

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

please give one example.

Re: regarding inner join

Former Member — Mon, 10 Sep 2007 09:15:01 GMT

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á

Re: regarding inner join

Former Member — Mon, 10 Sep 2007 09:22:18 GMT

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.

Re: regarding inner join

varma_narayana — Mon, 10 Sep 2007 09:49:24 GMT

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