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 the steps to be followed to set lockobjects? : sap abap data dictionary
What is difference between float and packed data type?
What are the requirements a dialog program must fulfill?
did u done enhancement framework?how u implemented?
Explain the difference between domain and data element?
when run my program in se38 it was showing output, when i take background execution and giving printer details it was shoing out put. but in SP01 when i give the Spool Request Number it was showing not yet processed entire page why it happens i dont know please give me a solution.
What is the length of function code at user-command?
What is a size category?
What is meant by authorization? : sap abap hr
What is the difference between getting and get late?
What is the collect statement?
What is the function of the transport system and workbench organiser? : abap data dictionary
Give examples of transparent table?
List the events in abap/4 language?
IN SCRIPTS IF WE HAVE EMPTY SECOND LAYOUT AND IF WE HAVE MENTIONED ABOUT IT IN NEXT PAGE ATTRIBUTE THEN IN OUTPUT HOW WE GET THE SECOND PAGE OUTPUT.