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

What is the difference between dbm cfg and db cfg file in db2 ?

1528


Can you use max on a char column?

1089


What is the difference between spufi and qmf?

1122


Discuss about db2 bind?

1088


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1727


What are union and union all?

976


What is the difference between plan and package in db2?

1104


Is ibm db2 open source?

1065


What is the use of value function?

1143


Explain the function done by data manager?

1273


What is explain plan in db2?

981


What is the clustering index in the db2 database?

996


Mention data types used in db2 ?

1152


How does coalesce work?

1010


can all users have the privilage to use the sql statement select * (dml)?

1160