inner join & oter join

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

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

[Former Member]

Hi,

Chcek out the link below

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

[Former Member]

Check this out

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

[Former Member]

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