topic Re: inner join & oter join in Application Development and Automation Discussions

inner join & oter join

Former Member — Thu, 31 Jul 2008 06:40:00 GMT

Hi Experts,

I m new learner of ABAP. I wanna know

How can we access data from multiple table .

I know we need inner join and outer join.

How could it used? What is inner and outer join?

What is the difference between them?

Plz clearify this through example and ur comments.

Regards,

Sandeep

Re: inner join & oter join

Former Member — Thu, 31 Jul 2008 06:41:11 GMT

Hi,

You can access data from multiple table by using INNER / OUTER join or FOR ALL ENTRIES.

In case of join , we write OPEN SQL QUERY to fetch data from multiple table and store it into an compatible internal table. But here the database fetches are comparetively more so it leads to performance issue.

for details in Join Check the Link

http://help.sap.com/saphelp_nw70/helpdata/en/cf/21ec77446011d189700000e8322d00/content.htm

Re: inner join & oter join

Former Member — Thu, 31 Jul 2008 06:41:35 GMT

yes, but i want to know about inner join and outer join.

Edited by: sandeep dubey on Jul 31, 2008 8:44 AM

Re: inner join & oter join

Former Member — Thu, 31 Jul 2008 06:43:44 GMT

Hi,

Chcek out the link below

www.sap-img.com/abap/what-is-inner-and-left-outer-join.htm

Re: inner join & oter join

Former Member — Thu, 31 Jul 2008 06:43:44 GMT

Check this out

http://help.sap.com/erp2005_ehp_03/helpdata/EN/cf/21ec77446011d189700000e8322d00/frameset.htm

Re: inner join & oter join

Former Member — Thu, 31 Jul 2008 06:44:15 GMT

Check these links-

http://www.sap-img.com/abap/select-statement-with-inner-join-is-taking-forever.htm

http://www.thespot4sap.com/articles/SAPABAPPerformanceTuning_InnerJoinStatement.asp