Skip to Content
0
Former Member
Feb 27, 2009 at 09:41 AM

inner join

33 Views

Is it possible to get output without using inner join?

:

select abukrs bnetwr bmwsbk bvbeln b~kunrg

ckunnr clifnr

alifnr axblnr

into corresponding fields of table itab1

from vbrk as b

inner join bsik as a on bvbeln = axblnr

inner join kna1 as c on bkunrg = ckunnr

where a~bukrs IN s_bukrs.