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


What is an inner join, and an outer join ?



What is an inner join, and an outer join ?..

Answer / 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

More DB2 Interview Questions

Name the different types of Table spaces.

5 Answers   IBM,


what is the differences between spufi and qmf and which is better?

4 Answers   Accenture, Cap Gemini,


can any one give the list of some important sql abend codes which r frequently asked in interviews?

2 Answers  


What is ibm db2 connect?

0 Answers  


Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.

3 Answers   IBM,


what is different three logs in DB2?

1 Answers   Syntel,


How to take backup of table in db2?

0 Answers  


Where can you declare a cursor in a cobol-db2 program?

0 Answers  


DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

4 Answers   Accenture,


what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........

1 Answers  


Are views updateable?

0 Answers  


Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

1 Answers  


Categories