topic Re: Inner join in Application Development and Automation Discussions

Inner join

former_member224008 — Thu, 27 Nov 2008 04:24:45 GMT

hi,

how many innerjoin can be used in single select query.

regards,

ARUN

Re: Inner join

Former Member — Thu, 27 Nov 2008 04:27:13 GMT

you can use more than one inner join.

and you can use more than 1 table

its alwayas a good practice not to combine more than 4 tables

Edited by: AD on Nov 27, 2008 6:14 AM

Re: Inner join

Former Member — Thu, 27 Nov 2008 04:28:28 GMT

Hi Arun,

I think we can do three .even more.

but it gives performance issue better go for for all entries

Regards

Re: Inner join

Former Member — Thu, 27 Nov 2008 04:32:09 GMT

yes you can use inner join for 3 tables.check this for inner join on 3 tables

http://www.sap-img.com/abap/inner-joins.htm

this should help you

regards

Aakash Banga

Re: Inner join

Former Member — Thu, 27 Nov 2008 04:50:12 GMT

Hi,

U can use more than one inner join. If u use more than 3 inner joins it will be a performence issue,

See below sample code,

SELECT a~anlage

b~devloc

c_{equnr c}serge c_{matnr c}sernr

FROM eastl AS a

INNER JOIN egerh AS b

ON a_{logiknr EQ b}logiknr

INNER JOIN equi AS c

ON b_{equnr EQ c}equnr

INTO TABLE li_device

FOR ALL ENTRIES IN li_ocm

WHERE a~anlage EQ li_ocm-anlage AND

a~ab LE ws_last_day_month AND

a~bis GE ws_last_day_month AND

b~devloc NE space AND

c~serge IN s_device.

Let me know if u have any other issues,

Regards,

Kusuma.

Re: Inner join

Former Member — Thu, 27 Nov 2008 05:11:30 GMT

Hi Arun,

There is basically no limit on that. You can use inner joins for 'N' number of tables. But Rememer that join may worse your performance.

Be careful with inner join, it's a good solution when you have the relation 1<->n but not with relation

n <-> n.

Do check this Link for performance analysis.

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/86a0b490-0201-0010-9cba-fd5c804b99a1

Thanks

Nitesh

Re: Inner join

former_member224008 — Thu, 18 Dec 2008 07:48:10 GMT

thanks for all