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 are system variable in abap?
I am getting the (first) page number and the remaining records displayed in another list in another page BUT the PAGE Number is not displayed? What is the code/solution?
What is help view?
What are the disadvantages of using explicit enhancement?
How to debug a sapscript?
Control Break statements- At new...endat.
What is the difference between abap and hr abap? : abap hr
how to track records from data dictionary?
What is a size category?
what is difference between (internal table types)standard table and sorted table in sap abap....
What is buffering allowed but switched off?
What are authorization objects and what statement is used to perform an authorization check in an abap program?
How can we set the table spaces and extent sizes? : abap data dictionary
What are the differences between transparent tables, pooled tables & cluster tables? : abap data dictionary
What is repository info. Systems? : abap data dictionary