topic Re: Problem with LEFT OUTER JOIN in Application Development and Automation Discussions

Problem with LEFT OUTER JOIN

Former Member — Thu, 25 Aug 2005 23:58:44 GMT

Hi,

I am trying run the following query -

SELECT RSECTAB~MANDT into (RSECTABMANDT)

FROM RSECTAB LEFT OUTER JOIN RSPSP ON RSECTAB_{MANDT = RSPSP}MANDT LEFT OUTER JOIN RSADD ON RSPSP_{MANDT = RSADD}MANDT.

I get this -

Error

ABAP Query failed to execute with the following error Unable to compare with "RSPSP~MANDT". A table can be joined with a maximum of one other table using LEFT OUTER JOIN..

What does this error mean?

Thanks,

Sheetal

Re: Problem with LEFT OUTER JOIN

Former Member — Fri, 26 Aug 2005 00:08:59 GMT

That you cannot have more than two tables in this select statement with outer join Try with two tables and see if you get this error.

Re: Problem with LEFT OUTER JOIN

Former Member — Fri, 26 Aug 2005 02:06:05 GMT

You can not join the tables with "mandt" field.mandt field tells about the client number.

you have to use another field (Index or key) in the tables for join.

Yad

Re: Problem with LEFT OUTER JOIN

Former Member — Fri, 26 Aug 2005 02:09:44 GMT

correction in the above statement:

mandt field is not a client number, but you can not join with that fields.

Thanks,

Yad

Re: Problem with LEFT OUTER JOIN

Former Member — Fri, 26 Aug 2005 02:48:52 GMT

Hi, you can change original code like following:

SELECT RSECTAB~MANDT into (RSECTABMANDT)

FROM <b>RSPSP</b>

LEFT OUTER JOIN <b>RSECTAB</b> ON RSECTAB_{MANDT = RSPSP}MANDT

LEFT OUTER JOIN RSADD ON RSPSP_{MANDT = RSADD}MANDT.

the left outer join can only from same table, E.G.

left outer join B to A

left outer join C to A

but can't

left outer join A to B

left outer join B to C

Only the inner join can do like above.

And another point is (RSECTABMANDT), what's it means? a workarea? if it is a workarea, you forget a SINGLE before RSECTAB~MANDT.

Hope it will be helpful

Thanks a lot