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 company code? : sap abap hr
what is the purpose of BAPI BAPI_CUSTMATINFO_GETLIST What is input and output of this BAPI.
What are the uses of interactive reporting?
What is append search help? : sap abap data dictionary
What are the types of subroutines?
What is the difference between field-group header and other field groups? : abap modularization
A field containing currency amounts (data type curr) must be assigned to a reference table and a reference field. Explain.? : abap data dictionary
Have you processed BDCs ?
How many ways can a sap system be accessed?
What are the steps to be followed to set lockobjects? : sap abap data dictionary
What are the objects of the abap dictionary or what types of objects can be created in the abap dictionary? : abap data dictionary
What is human resource information systems (chris)? : sap abap hr
what are the important fields while preparing sales order,inquiry?
How the at-user command serves mainly in lists?
How do you Export a session ?