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

Difference between sap script and report?

1258


What is the function of the transport system and workbench organiser? : abap data dictionary

1116


What are the function modules used to create batch input session? : abap bdc

1248


What are the check tables and value tables?

1235


What is the significance of delivery class?

1098


What are the functional areas?

1108


What is view? Different types of view. Explain?

1100


Name a few data dictionary objects? : abap data dictionary

1176


Can you give the Example for the structure of an ABAP program? REPORT... NODES: SPFLI, SFLIGHT. DATA:... INITIALIZATION. AT SELECTION-SCREEN. START-OF-SELECTION. GET SPFLI... GET SFLIGHT... GET SPFLI LATE. END-OF-SELECTION. FORM... ENDFORM.

1150


What is an interface? In what scenario we use interface? What is the difference between abstract class and interface?

1428


Example of table cluster and cluster tables.

1181


How is collect statement different from append?

1078


What is the use of 'for all entries'?

1117


Have you set up a back ground job? How to create a background job without a variant ? : abap bdc

1151


Different types of locks?

1103