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 are the differences between domain and data element?
Setting up a BDC program where you find information from?
What are Tickets in Realtime ?
1)can any body tell the transport request number concept and 2)there are 3 screens in one screen u have uploaded the resume and second screen also u have done the same thing but when u are uploading the resume in third screen u got some error in somewhere else but whatever u have uploaded the resume in 1 and 2 should not
When will the current screen processing terminates?
What does hide statement do?
Can you delete a domain, which is being used by data elements? : abap data dictionary
What are logical databases?
Explain the differences between interactive and drill down reports?
What is value table?
Select query optimisation
what is mean be On Change of in Control Break statement
What is asap methodology? : sap abap hr
how to genernate 21 sencondary index
Can we create field without data element? If yes, how?