what is the diffrence between inner and outer join
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Which event in Reports is equal to PBOin Module Pool Program?
How many types of data classes are there in sap abap? : abap data dictionary
how will u interact with client if neccessary?
Explain how to write a bdc - how do you go about it?
How to make smartform output into PDF?what r the step and requirments?
What are indexes?
i have two purchase orders in smartform.i need to print them in two different pages.how to do that.
How to Modify the standard invoice and sales order form to generate purchase order for printing and upload the company logo. plz mention the detail coding Tahnks, Rahul
In Dialog program Syntax of Synchronous and Asynchronous?
In selection screen, I have three fields, plant material number and material group. If I input plant how do I get the material number and material group based on plantdynamically?
What are subroutines? : abap modularization
Difference between domain and data element? What are aggregate object?