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

Explain the different types of screen keywords?

1093


The commands through which an abap/4 module can “branch to “ or “call” the next screen are?

1158


What is meant by authorization? : sap abap hr

1183


why to create a custom BAPI if the BAPI already exists? y to find BAPI again? frankly even i dint undstnd tne question properly. if any one come across this q please do anser me.

2235


what are the two methods of modifying sap standard tables? : abap data dictionary

1126


What is sap locking?

1069


What kind of financial periods exist in sap? What is the relavent table for that?

1133


How to convert normal function module to bapi?

2061


What are extracts?

1031


Can a domain, assigned to a data element be changed? : abap data dictionary

1058


What is projection view?

970


what is field string ? & where we are using field strings?

1997


How can we achieve MVC ?

1343


Can we display a list in a pop-up screen other than full-size stacked list?

1116


What are the advantages of abap query tool?

1037