topic Nested INNER JOIN in Application Development and Automation Discussions

Nested INNER JOIN

dhiraj_bhatia1 — Wed, 13 Apr 2011 12:30:29 GMT

Hi all,

I am joining my three tables using the inner join..

here is code

Select a_{empid b}deptid

into corr fields of table lt_emp

from ( emp as a INNER JOIN dept as b

ON ( b_{deptid = a}deptid ) )

INNER JOIN loc as c

ON ( b_{deptid = a}deptid )

WHERE a~depid EQ lt_dept-deptid.

deptid is present in all three tables but still my lt_emp table is coming empty...

Can anyone suggest me any other way of joining three tables with only one select query..

Thanks n Regards,

Dhiraj B.

Former Member — Wed, 13 Apr 2011 13:33:02 GMT

use this.

if it_dept is not initial.

Select a_{empid b}deptid

into corr fields of table lt_emp

from ( emp as a INNER JOIN dept as b

ON ( b_{deptid = a}deptid ) )

INNER JOIN loc as c

ON ( c_{deptid = b}deptid )

for all entries in it_dept

WHERE a~depid EQ lt_dept-deptid.

endif.

because in your code you are checking deptit from table it_dept in where condition,

which will contain only the last values stored in the header of table it_dept.

this is why i have used for all entries here.

thi for all entries will fetch the data from all the table for all the values matches in table it_dept.

try this and i hope this will work for you.

thanks

Former Member — Wed, 13 Apr 2011 15:15:55 GMT

It should be something like this:

SELECT SINGLE a_{matnr c}werks

INTO (l_matnr , l_werks)

FROM mara AS a INNER JOIN makt AS b

ON ( a_{matnr = b}matnr )

INNER JOIN marc AS c

ON ( b_{matnr = c}matnr )

WHERE a~matnr EQ l_matnr1.

IF sy-subrc = 0.

ENDIF.

For your query the second on condition is not correct.