Difference between inner join and outer join in abap
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
What data is contained in data dictionary? : abap data dictionary
What is the difference between field-group header and other field groups? : abap modularization
What are the different types of locks? : abap data dictionary
What are the commands used for interactive reports?
What is asynchronous update?
What are the advantages and disadvantages of different types of bdc's?
Describe the data classes?
What is tcode se16? For what is it used.
If A is the super class of B. And both the classes have constructor. We create an object of class B. Then which constructor will be called? If both then in which order?
How do you document ABAP programs? Do you use program documentation menu option?
Explain how is batch input process different from processing on line?
How to use messages in lists?
Describe the difference between macro and subroutine?
How is the command suppress-dialog useful?
How do we assign dynamic views while creating material master and generating bdc? : abap bdc