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 |
wat is the difference between A-gate & W-gate?where are they used?
How to transfer the objects? Have to transferred any objects?
In SAP Query with out know user that query can we execute?
How to display dynamic logo's in Smartforms? i mean to say different logo's on different pages?
2 Answers Altimetrics, Cap Gemini,
I have two applications one is 'cov letter' and Purchase order.how will you process these forms in your driver program and tell me the sequence of the FM?
What is buffering allowed but switched off?
How to handle error in session method? : abap bdc
Can we use Session method & Call transaction both in one BDC if yes please give me example and scenario where we use this ?
in report gui we are giving customer number if it is wrong entry then how to write the code to restrict wrong entry?
What are the internal tables and work area?
How to test a script?how to find versions in scripts?
How to see the error message if we use call transaction method in BDC ??