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
Explain buffering
List the various components of the enterprise structure in systems, applications, and products (sap) in human capital management (him)? : sap abap hr
How does the system handle roll areas for external program components?
Which transaction code can I use to analyze the performance of abap program?
Why do we use logical blocks in abap program?
What are the attributes of the data in data dictionary? : abap data dictionary
In se11 -->Tech. settings --> Data class. If I save table as Mater data OR Transaction data, what effect will it has for 'Storage' in Database after activation. or In Database how it will store in both the cases.
can anybody give me functional specification (or table name & field names) of stock analysis report, work in progress report,generating vendor detailed list
What is the BAPI_CUSTMATINFO_GETDETAILM used for? what is the input and output of this bapi.
In select-options, how to get the default values as current month first date and last date by default?
wht is the diff. b/n initialization and lotus of event
How can we use multiple transactions by using bdc_insert? : abap bdc
If your project is support project ? when is your implementation has completed ?
What are the organizational related infotypes? : abap hr
What are the check tables and value tables?