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

Comment whether the cursor is closed during commit or not.

1047


What is a buffer in memory?

1017


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1194


How do I add a column to an existing table in db2?

981


What is a plan and package in db2?

1054


What are the full forms of spufi and dclgen and why are they used?

1029


How would the varchar column remarks defined?

1040


What is sqlca?

1006


Explain packages.

1068


How do I delete a table in database?

986


What is a storage group (stogroup)?

1199


How is a typical db2 batch pgm executed?

1122


How to find the number of rows in a db2 table?

1077


Define data page.

1021


Is db2 a programming language?

994