Answer Posted / apoorv sharma
You use INNER JOIN to return all rows from both tables where
there is a match. ie. in the resulting table all the rows
and colums will have values.
In OUTER JOIN the resulting table may have empty colums.
Outer join may be either LEFT or RIGHT
LEFT OUTER JOIN returns all the rows from the first table,
even if there are no matches in the second table.
RIGHT OUTER JOIN returns all the rows from the second table,
even if there are no matches in the first table.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is the max. No. Of structures that can be included in a table or structure? : abap data dictionary
What is a transport?
Can we create field without data element? If yes, how?
Can we handle two transaction codes in the same program using call transaction bdc input method? : abap bdc
How is collect statement different from append?
Explain the relationship between a functional area, user group, and query when developing queries using the sap query tool?
How to read 5th record from Hash Internal Table?
What is the function of a data element? : abap data dictionary
Structures can contain data only during the runtime of a program (t/f) : abap data dictionary
hi,i worked mostly in core abap.know iam assigned to XI utility project.can u experts let me know what r the basic things i need to learn to work in XI utility project.i already searched in forum.thanks in advance.
What is difference between dependent and independent data?
How would you set the formatting options statically and dynamically within a report?
Explain the call transaction method? : abap bdc
What are the functional areas?
Why do we use FOR ALL ENTRIES and what is the pre-requisite
