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...

what is the diffrence between inner and outer join

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


Please Help Members By Posting Answers For Below Questions

Explain the client concept of sap.

978


what is bapi,badi,bdc,ale idocs?

2164


How do you restrict the data to be entered in the payroll area? : sap abap hr

1002


What are domains and data element? : abap hr

1019


what is sap scriptview ?

2179


What are the different types of parameters? How can you distinguish between different kinds of parameters?

939


What are the other modules integrated with om? : sap abap hr

951


Define infotype ? : abap hr

1199


What does the ‘suppress dialog’ do?

1403


How can you display frames (horizontal and vertical lines) in lists?

1047


Explain the difference between function group and function module?

1087


What was the requirement of IDoc in your project? How it was working?

1984


hi experts,,, what is meant by documentation? test casr preparation? documentation and preparation and Tcode for this? quality and releasing? test case scenario?

2134


How can we declare a table control in the abap/4 program?

1103


Does the external program run in the same sap luw as the caller, or in a separate one?

1054