Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Difference between inner join and outer join in abap

Answer Posted / >>>accenture>>&

Resulting set for inner join

The inner join joins the columns of every selected line on
the left- hand side with the columns of all lines on the
right-hand side that jointly fulfil the join_cond
condition. A line in the resulting set is created for every
such line on the right-hand side. The content of the column
on the left-hand side may be duplicated in this case. If
none of the lines on the right-hand side fulfils the
join_cond condition, no line is created in the resulting
set.

Resulting set for outer join

The outer join basically creates the same resulting set as
the inner join, with the difference that at least one line
is created in the resulting set for every selected line on
the left-hand side, even if no line on the right-hand side
fulfils the join_cond condition. The columns on the right-
hand side that do not fulfil the join_cond condition are
filled with null values.

Is This Answer Correct ?    9 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What data is contained in data dictionary? : abap data dictionary

1053


What is the difference between field-group header and other field groups? : abap modularization

941


What are the different types of locks? : abap data dictionary

1055


What are the commands used for interactive reports?

1024


What is asynchronous update?

987


What are the advantages and disadvantages of different types of bdc's?

1014


Describe the data classes?

977


What is tcode se16? For what is it used.

1041


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?

1345


How do you document ABAP programs? Do you use program documentation menu option?

1078


Explain how is batch input process different from processing on line?

981


How to use messages in lists?

1008


Describe the difference between macro and subroutine?

1164


How is the command suppress-dialog useful?

1053


How do we assign dynamic views while creating material master and generating bdc? : abap bdc

1099