Join

[Former Member]

Hi,

Can ne1 plz help me out by telling me a simple code that uses the concept of the join query. Join is very confusing for me.

Thanks & Regards,

Mohit Goel.

[Former Member]

Hi,

check this code..

SELECT A~MATNR B~WERKS
             FROM MARA AS A
             INNER JOIN MARC AS B
             ON A~MATNR = B~MATNR
             WHERE A~MATNR = 'TEST123'.

Thanks

Naren

[Former Member]

Check these examples -

Example of a JOIN containing more than 2 tables: Select all flights from Frankfurt to New York between 10th and 20th September 1997 where there are free places, and display the name of the airline.

DATA: BEGIN OF itab occurs 0,

FLIGHT TYPE SFLIGHT,

PFLI TYPE SPFLI,

CARR TYPE SCARR,

END OF itab.

SELECT * INTO table itab

FROM ( SFLIGHT AS F INNER JOIN SPFLI AS P

ON F_{CARRID = P}CARRID AND

F_{CONNID = P}CONNID )

INNER JOIN SCARR AS C

ON F_{CARRID = C}CARRID

WHERE P~CITYFROM = 'FRANKFURT'

AND P~CITYTO = 'NEW YORK'

AND F~FLDATE BETWEEN '19970910' AND '19970920'

AND F_{SEATSOCC < F}SEATSMAX.

TABLES: SCUSTOM, SBOOK.

SELECT SCUSTOM_{NAME SCUSTOM}POSTCODE SCUSTOM~CITY

SBOOK_{FLDATE SBOOK}CARRID SBOOK_{CONNID SBOOK}BOOKID

INTO (SCUSTOM-NAME, SCUSTOM-POSTCODE, SCUSTOM-CITY,

SBOOK-FLDATE, SBOOK-CARRID, SBOOK-CONNID,

SBOOK-BOOKID)

FROM SCUSTOM LEFT OUTER JOIN SBOOK

ON SCUSTOM_{ID = SBOOK}CUSTOMID AND

SBOOK~FLDATE = '19971015'

ORDER BY SCUSTOM_{NAME SBOOK}FLDATE.

WRITE: / SCUSTOM-NAME, SCUSTOM-POSTCODE, SCUSTOM-CITY,

SBOOK-FLDATE, SBOOK-CARRID, SBOOK-CONNID,

SBOOK-BOOKID.

ENDSELECT.

For more details check link

http://www.geocities.com/rmtiwari/Resources/Utilities/ABAPReference/ABAPReference.html

Check JOIN Command.

ashish