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 netweaver???what is the relationship with ABAP?

2123


What are authorization objects and what statement is used to perform an authorization check in an abap program?

963


What is sap script? Describe its components.

1031


How to create user interfaces for lists?

969


stock transfer from one plant to another plant ? i want the total description.

1999


In Table Field when display the Name, whose first charecter should be capital letter and rest will be small letter.

2008


Explain buffering concept usage?

961


What is the difference between ABAP and HR ABAP

3526


What are the differences between table and structure in data dictionary?

1047


i have executed a report via back ground job, in this report i have used enqueue and dequeue function modules on a table, but before releasing the lock(before dequeue function module is not call) job gives the dump, so the lock is not released the table, here my question is how to set the lock automatically release the there is a short dump before calling the dequeue module?

2147


What is your approach to find exit and BAdi?

1260


What is sap abap data classes?

1015


What are the buffering options in abap?

1064


Can i know some of the Realtime tickets that anyone has been faced ?

2092


What is meant by read lock? : sap abap data dictionary

984