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

Question Posted / s

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

Explain about cursor stability?

1056

What is dpf in db2?

1114

What is clone table?

1052

What is buffer pool and list some of them?

1036

Explain about rct in db2?

1112

What is the use of commit in db2?

1083

What is the difference between oracle and db2?

1112

What is the difference between bind and rebind in db2?

1455

Can we delete records from view?

970

Explain correlated sub-queries.

1036

What is the role of union all and union

1129

What happens in bind step in a db2 program?

977

What is access path in db2?

989

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2394

What is a bind card?

1222