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

Explain an outer join?

Answer Posted / vamsikrishnamraju

An outer join operation returns all the rows returned by an
inner join plus all the rows from one table that do not
match any row from the other table. An outer join can be
left, right, or full, depending on whether rows from the
left, right, or both tables are retained

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which component is responsible for processing sql statements and selecting access paths?

1176


What types of tables are there in the db2 database?

1101


What does reorg do in db2?

1074


Which isolation level provides highest data integrity?

1186


what is a corelated subquerry?

1167


What is clone table?

1114


How can deadlocks be resolved?

991


What are concurrency issues?

1170


What is bind plan?

1095


Why do we use cursor?

1162


What is the physical storage length of time data type?

1175


What is the physical storage length of date data type?

1304


Is it possible to create an Instance in DB2 using DB2 Control Center ?

1150


What is universal database?

1118


What are packages in db2?

1072