10-19-2007 12:07 PM
Hi ,
Can anyone explain me the exact purpose of Outer join .
What is the difference between INNER JOIN and OUTER JOIN.
Regards,
Phyrsoe.
10-19-2007 12:10 PM
INNER JOIN : gets a result when the record in table A links to a record in table B
When A or B has no entry for the linking pin, you will get a result.
OUTER JOIN : will get also a result for the second situation, so when A or B has no entry for the linking pin
regards,
Hans
10-19-2007 12:26 PM
10-19-2007 12:35 PM
hi
<b>Resulting set for inner join</b>
The inner join joins the columns of every selected line on the left- hand side with the columns of all lines on the right-hand side that jointly fulfil the join_cond condition. A line in the resulting set is created for every such line on the right-hand side. The content of the column on the left-hand side may be duplicated in this case. If none of the lines on the right-hand side fulfils the join_cond condition, no line is created in the resulting set.
<b>Resulting set for outer join</b>
The outer join basically creates the same resulting set as the inner join, with the difference that at least one line is created in the resulting set for every selected line on the left-hand side, even if no line on the right-hand side fulfils the join_cond condition. The columns on the right-hand side that do not fulfil the join_cond condition are filled with null values.
reward if u find use ful
regards
Nagesh.Paruchuri
10-19-2007 12:45 PM
Hi,
Check below SAP help.
http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ec77446011d189700000e8322d00/content.htm
Regards,
Atish