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

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

What is JOIN and different types of JOIN.

Question Posted / vamsikrishnamraju

Answer Posted / vamsikrishnamraju

Sometimes we have to select data from two or more tables to
make our result complete.
inner join
left join
right join

Is This Answer Correct ?    7 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the uses of db2 optimizer?

1299

What is the use of runstats in db2?

1112

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

1134

What is cursor stability in db2?

1363

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2099

What is consistency token in db2?

1147

Define sqlca.

1117

How do I add a column in db2?

1049

How to view db2 table structure?

1022

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1109

What is db2 purescale?

1011

What are the 2 sqlcodes that are returned?

1196

What do you mean by commit and rollback?

1049

What type of database is db2?

971

How will you return the number of records in table?

939