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
Workbench request are client dependent or client independent
How to create any functions? How to go about it?
when u prefer lsmw?
Explain the Importance of pa20? : abap hr
what is mean be On Change of in Control Break statement
What is the length of function code at user-command?
What is the function of the correction system? : abap data dictionary
What is logo in sap script?
What is at exit-command:?
Did you use buffering?
Difference between sy-tabix and sy-index? Where it is used? Can you check sy-subrc after perform?
What are the types of indexes in abap?
What is the maximum number of structures that can be included in a table or structure
What is the difference between bdc_open_group and bdc_open_dataset. : abap bdc
What is the reserve command?
