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
From Excel to ABAP - Is batch mode possible ?
PLEASE HELP ANYONE ON THIS ISSUE,is there any problem with this function module :RHPQ_T77BX_ADD_QUALIS_OF_DPLAN. IT IS TRIGGERING BEFORE COMPLETION OF THE DEVELOPMENT PLAN but it has to trigger after compltion of development plan..this issue raised in my project..so reply urgently..thanks in advance..
data:zxyz type xyz. where xyz is a standard sap structure where it contains data type fields and line type (refer to other structure) fields. my question is how to assign values to field zxyz-str-matnr where str is a structure inside xyz structure.
How to transfer data into line items using batch input session method? : abap bdc
What are the differences between the table and the structure in the data dictionary in the sap abap?
THANKS ALL. i CLEARED THE INTERVIEW OF INFOSYS BASED ON THIS QUESTION SET. IT REALLY WORKS. LONG LIVE ALLINTERVIEW.COM
what is sales order confirmation and how can do design it in webdynpro. what is Tcode for the same?
Print options in smartforms?
What are the steps in creating screen ?
Difference between open sql and native sql? : abap data dictionary
How do you document ABAP programs? Do you use program documentation menu option?
Can you define a field without a data element?
Static and instance variable and method with live example. Why and when to use
Define external layer?
any 1 having notes on SAP-ABAP certification, or even if any 1 could provide the url for getting notes on SAP-ABAP certification, would be appreciated.