topic Re: inner join and outer join in Application Development and Automation Discussions

inner join and outer join

Former Member — Thu, 11 May 2006 17:55:20 GMT

hi,

what is the diff b/w inner join and outer join?

thanks regards,

kiran.

Re: inner join and outer join

Former Member — Thu, 11 May 2006 17:57:25 GMT

hi Kiran,

Check these to know the difference..

http://help.sap.com/saphelp_erp2005/helpdata/en/cf/21ec77446011d189700000e8322d00/frameset.htm

Regards,

Santosh

Note: Reward Points if helpful

Re: inner join and outer join

RichHeilman — Thu, 11 May 2006 17:58:09 GMT

<i>

In an inner join, a line from the left-hand database table or join is only included in the selection if there is one or more lines in the right-hand database table that meet the ON condition <cond>. The left outer join, on the other hand, reads lines from the left-hand database table or join even if there is no corresponding line in the right-hand table.

</i>

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb39c4358411d1829f0000e829fbfe/frameset.htm

Regards,

Rich Heilman

Re: inner join and outer join

Former Member — Thu, 11 May 2006 17:58:47 GMT

There is nothing called outer join.

There wil be only inner join which means you are slecting entries from both tables only if it meets the codition that the secong table's field matches with the first table's field.

REgards,

Ravi

Re: inner join and outer join

RichHeilman — Thu, 11 May 2006 18:00:52 GMT

Ravi, there is an "outer join".

Read the links provided.

Regards,

Rich Heilman

Re: inner join and outer join

Former Member — Thu, 11 May 2006 19:12:22 GMT

Note that Dr. Codd (the father of the Relational Database) created inner and outer joins based on the mathematical concepts of Unions and Intersections.