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
in bdc session method. if u run the record in fore ground manually i have a 7 records but at the time of record processing first record produces the error how can u process records manually in fore ground please tell me any one knows?
Explain what is step-loop? Explain all the steps?
Explain the data types of internal tables?
what is leave to TRANSACTION?
Explain the table, which contain the details of all the name of the programs and forms?
how to create module pool program using table controls based on selection criteria specified for sales document item in the first screen and item details in the second screen. plz mention the detail coding Tahnks, Rahul
What is the difference between RETURNING and CHANGING parameters for a method?
What are the table controls in bdc ? What is the difference between bdc and lsmw ?what is the difference between bdc and rfc ? : abap bdc
Write special commands of list?
Search help exit details.
What will exactly the hide statement do?
write a program for creation of customer quotation using BAPI 'BAPI_QUOTATION_CREATEFROMDATA'.
What is ps structure? : abap hr
IN SCRIPTS IF WE HAVE EMPTY SECOND LAYOUT AND IF WE HAVE MENTIONED ABOUT IT IN NEXT PAGE ATTRIBUTE THEN IN OUTPUT HOW WE GET THE SECOND PAGE OUTPUT.
What is an “on request field” statement?