Inner join performance suggest

[Former Member]

Hi i m new to inner joins just let me know am i correct in writing inner join using 2 tables mara and mrc.

select a_{matnr a}ersda a_{ernam a}meins b_{werks b}pstat into table itab from mara as a inner join marc as b on a_{matnr = b}matnr where matnr in s_matnr and werks in s_werks.

Frnds plzz suggest in which shuld i write my inner join to make it performance wise more efficient.

just help me how to write inner join using 3 tables.

thanking u all.

regards,

satya

Message was edited by:

satya ranjan

[Former Member]

Hi,

You are missing the ON addition..And in the where clause you should refer the fields with a~ or b~

select a_{matnr a}ersda a_{ernam a}meins b_{werks b}pstat into table itab

from mara as a inner join marc as b

<b>on a_{matnr = b}matnr</b>

where <b>a_{</b>matnr in s_matnr and <b>b}</b>werks in s_werks.

Thanks,

Naren

[Former Member]

I don't think the problem is with the join. But you have to make sure that s_matnr is not empty before executing this.

Rob

[former_member187255]

Satya,

Example of inner join using 3 tables...

select mara_{matnr mara}mtart marc_{werks marc}dispo

mard_{lgort mard}labst

into table itab

from mara

inner join marc

on mara_{matnr = marc}matnr

inner join mard

on marc_{matnr = mard}matnr

and marc_{werks = mard}werks

up to 10 rows.

Regards.

[Former Member]

Hi rcm,

i m getting confused yaar...

help me plzz...

regards,

satya

[Former Member]

OK - are you concerned about the performance or how to do the join?

Rob

[Former Member]

HI I M CONCERNED ABOUT JOIN.

THNKS

REGARDS,

SATYA

[Former Member]

Then Naren answered your question.

Rob