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 an inner join, and an outer join ?

Answer Posted / s

Inner Join return only matching rows whereas Outer Join
returns matching rows from both tables and unmatched rows
from either of the table depending on the join.
RIGHT outer Join returns matching rows and unmatched rows
from the right table.
LEFT outer join returns matching rows and unmatched rows
from the left table.

Is This Answer Correct ?    27 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can deadlocks be resolved?

991


Is the primary key a clustered index?

1200


Why do we bind in db2?

1273


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3202


What is consistency token in db2?

1191


What is ibm db2 used for?

1129


How does cobol compile db2 program?

1128


What is blu acceleration in db2?

1125


What is difference between isnull and coalesce?

1106


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1141


What is an instance in db2?

1084


What is db2 look?

1075


What is host variable?

1109


What is the default page size of buffer pools?

1166


What is a bind in db2?

1100