topic Inner join performance suggest in Application Development and Automation Discussions

Inner join performance suggest

Former Member — Fri, 23 Feb 2007 16:53:22 GMT

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

Re: Inner join performance suggest

Former Member — Fri, 23 Feb 2007 16:56:33 GMT

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

on a_{matnr = b}matnr

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

Thanks,

Naren

Re: Inner join performance suggest

Former Member — Fri, 23 Feb 2007 16:57:55 GMT

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

Re: Inner join performance suggest

former_member187255 — Fri, 23 Feb 2007 16:59:00 GMT

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.

Re: Inner join performance suggest

Former Member — Fri, 23 Feb 2007 17:16:31 GMT

Hi rcm,

i m getting confused yaar...

help me plzz...

regards,

satya

Re: Inner join performance suggest

Former Member — Fri, 23 Feb 2007 17:24:33 GMT

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

Rob

Re: Inner join performance suggest

Former Member — Fri, 23 Feb 2007 17:52:13 GMT

HI I M CONCERNED ABOUT JOIN.

THNKS

REGARDS,

SATYA

Re: Inner join performance suggest

Former Member — Fri, 23 Feb 2007 18:28:54 GMT

Then Naren answered your question.

Rob