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

What is the use of table control in bdc is it same in module pool table control? : abap bdc

1208


How are BAPI different from Normal function modules ?

2131


What are the basic object types? : sap abap hr

1147


Explain what is the significance of hide?

1095


List the various components of the enterprise structure in systems, applications, and products (sap) in human capital management (him)? : sap abap hr

956


What is the difference between retroactive accounting period, earliest retroactive accounting period? : sap abap hr

1151


What are the list of screen elements?

1008


On abap: did you set up a workflow? Are you familiar with all the steps for setting up a workflow?

1014


In sap scripts, how will you link form with the event driven?

983


What are the two ways for restricting the value range for a domain? : sap abap data dictionary

1281


Interactive Report that list purchase order details of a vendor. When the user double clicks on material number it shows detail list with fields matkl, meins, brgew, ntgew, gewei.The selection screen consist of sales organisation, distribution channel and material number. plz mention the detail coding Tahnks, Rahul

3689


What are the different types of the sap abap data dictionary objects?

1034


Can you define a field without a data element?

950


what is the purpose of BAPI BAPI_CUSTMATINFO_GETLIST What is input and output of this BAPI.

2562


What are Tickets in Realtime ?

2232