Answer Posted / saifur rahaman
difference between inner join and outer join is:
inner join means it selects same data only in both the
tables
outer join means first it selects same data and second it
selects different data from the both tables.
Outer Join:
There are three types of outer joins namely:
>>Left Outer Join---For retreiving all the columns from the
first table irrespective of the column match.
>>Right Outer Join---For retreiving all the columns from
the second table irrespective of the column match
>>Full Outer Join---For retreiving all the columns from
both the tables irrespective of column match.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Difference between sap script and report?
What is the function of the transport system and workbench organiser? : abap data dictionary
What are the function modules used to create batch input session? : abap bdc
What are the check tables and value tables?
What is the significance of delivery class?
What are the functional areas?
What is view? Different types of view. Explain?
Name a few data dictionary objects? : abap data dictionary
Can you give the Example for the structure of an ABAP program? REPORT... NODES: SPFLI, SFLIGHT. DATA:... INITIALIZATION. AT SELECTION-SCREEN. START-OF-SELECTION. GET SPFLI... GET SFLIGHT... GET SPFLI LATE. END-OF-SELECTION. FORM... ENDFORM.
What is an interface? In what scenario we use interface? What is the difference between abstract class and interface?
Example of table cluster and cluster tables.
How is collect statement different from append?
What is the use of 'for all entries'?
Have you set up a back ground job? How to create a background job without a variant ? : abap bdc
Different types of locks?