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
In tm, if a group of employees gets 10 days of annual leave, what will be the time evaluation status? : sap abap hr
how to modify the standard method as per your requirement
What is modularization and its benefits? : abap modularization
Why do we use types statement in abap programming?
What are the buffering options in abap?
Difference between .Include and .append?
What are base tables of an aggregate object?
Can a domain, assigned to a data element be changed? : abap data dictionary
What are the internal tables and work area?
Suppose there is a secondary index on 4 non-key fields A,B,C & D. There are 3 select queries :- a) one on basis of A, B, C , D b) Second on basis of A, B, C c) Third on basis of D, C,B, A In which all situations , the above secondary index will be used?
Which transaction code can I use to analyze the performance of abap program?
Define infotype ? : abap hr
What is a data dictionary? : abap data dictionary
What are the function modules that are generated when you activate a lockobject? : sap abap data dictionary
Where do you use help views?
