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
outer join means first it selects same data and second it
selects different data from the both tables.
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|
What will happen if we write “WRITE” statement in the TOP_OF_PAGE? Can we write?
How would you add fields to the sapscript without modifying the print program?
How to debug ABAP workflow ?
How many types of data classes are there in sap?
Explain what is sequence of event triggered in report?
please tell me. different ways of find out the user exist?what is the basic difference between ,user exist ,BAdi,Bapis?
how can we use the text randomly or circularly in smartforms.... means... suppose i have 'abap' horizantally... but i want it in vertically... how can... plz any body tell me this....
DO SERVERS IN EVERY COMPANY HAVE A SPECIFIIC NAME CAN I KNOW THE SERVER NAME OF IGATE AND ITS GEOGRAPHICAL LOCATION AND HOW MANY SERVERS DO A COMPANY WILL HAVE FOR SAP
in real time with the help of scripts what we can do?
What is the differences between structure and table in the data dictionary in abap?
What are the advantages of logical databases : abap hr
differnce between user and customer exit