Difference between inner join and outer join in abap
Answer / >>>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 |
In Interactive Report ,can I have more than 20 interactive Lists? Is it Possible ,If Yes How can i do it?
how can u write in single program call transaction and session method logic? if u write logic in call transaction ,is there any errors ? how can u see in session ?
Can we create a field without data element ? If yes what is the difference?
what is field string ? & where we are using field strings?
could you tell me the difference between an INTERFACE AND CONVERSION?
What are authorization objects and what statement is used to perform an authorization check in an abap program?
How to create a check box/option button in a list?
what is table maintainence?
when u create an index in Data Dictionary..how do we call it in a program or report..?
If you are at 3rd list how can you back to 1st list?
have you used performance tunig?what major steps will you use for those
What are standard layouts sets in the sap script?