Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between inner join and outer join in abap
- 1 Answers
- 16573 Views
- I also Faced
- E-Mail Answers
Answer Posted / >>>accenture>>&
Resulting set for inner join
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.
Resulting set for outer join
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.
| Is This Answer Correct ? | 9 Yes | 9 No |
Post New Answer View All Answers
Can we make use of flow logic control key words in abap/4 and vice-versa?
What is an abap?
What are the functional areas? User groups? And how does abap/4 query work in relation to these?
How to add a column to a table control while using alphanumerical layout editor ?
What is the full form of spro? : sap abap hr
What are screen painter? Menu painter? Gui status?
What are the check tables?
What is tcode se16? For what is it used.
What is SAP Data conversion ?
What is the maximum number of match code id's that can be defined for one match code object ?
Explain the difference between float and packed data type?
What are the arithmetic operators in the sap abap?
What is a multiple line field?
How will you define posting procedures?
What is filter dependent BADI?
