syntax for right outer join

Former Member — Wed, 27 Jun 2007 09:15:42 GMT

hello gurus,

i am trying to execute the code in ALVROBOT(www.alvrobot.com.ar) for various scenarios.

i found that ,while mentioning LEFT OUTER JOIN/ RIGHT OUTER JOIN as JOIN TYPE certain issues arise.

for LEFT OUTER JOIN,there shudnt be a WHERE condition in RIGHT SIDE TABLE of the LEFT OUTER JOINED TABLE.

what is the simialr correct syntax for RIGHT OUTER JOIN.

I dont get f1 HELP for RIGHT OUTER JOIN in SAP DOCUMENTATION.

version 5.0..

is it obsolete?

Re: syntax for right outer join

Former Member — Wed, 27 Jun 2007 09:21:49 GMT

HI,

ACCORDING TO MY KNOWLEDGE THERE IS NO RIGHT OUTER JOIN THERE IS ONLY LEFT OUTER JOIN.

IT IS WRITTEN AS

SELECT MARA~MATNR

MARA~MTART

MARC~WERKS

INTO TABLE ITAB

FROM MARA LEFT OUTER JOIN MARC

ON MARA_{MATNR EQ MARC}MATNR

WHERE MARA~MATNR IN S_MATNR.