Inner join statement correction

Former Member — Wed, 28 Apr 2010 13:00:09 GMT

For three different tables we can write select statement like below?if any correction pleas correct it.

select *

from ekko as a

inner join ekpo as b

on a_{ebeln = b}ebeln

inner join ekkn as c

on b_{ebeln = c}ebeln

into corresponding fields of table gt_data

where a~zvoyn in s_zvoyn

and a~ekgrp in s_ekgrp

and a~ebeln in s_ebeln

and a~zbookref2 in s_bookr

and a~lifnr in s_lifnr

and a~waers in s_waers

and b~matnr in s_matnr

and c~kostl in s_kostl..

Re: Inner join statement correction

Former Member — Wed, 28 Apr 2010 13:37:29 GMT

HI Venkee,

Yes this query will work but to improve the performance

use the required field names in the order as they are in the table instead of ' * '

declare an internal table with this fields. assume gt_data

and

avoid using into corresponding.

Regards,

Md Ziauddin.