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
What are the different types of work process?
If A is the super class of B. And both the classes have constructor. We create an object of class B. Then which constructor will be called? If both then in which order?
Can multiple abap systems connect to abap database?
What are the uses of the information in the data dictionary? : abap data dictionary
Explain the function module in bdc?
What are the buffering types?
Explain the different types of view?
How do you find the tables to report from when the user just tell you the transaction he uses? And all the underlying data is from SAP structures?
Program for Prime numbers and Matrix plz explain me the procedural method with steps
What is meant by hot spots? : abap data dictionary
What are the fields in a bdc_tab table? : abap bdc
What are multiple use BADIS?
If I want to execute a program only in background not in foreground is there any option for this? : abap bdc
Explain what is sap script? What is the purpose of sap script?
How can cluster table be created?
