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

What is difference between isnull and coalesce?

0 Answers  


Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......

2 Answers  


Is db2 free?

0 Answers  


how do u update the faltfile into db2 table ?

4 Answers   RBS, TCS,


What is bind package and plan in db2?

0 Answers  


What is an alias and how does it differ from a synonym?

3 Answers  


how to identify the pseudo conversation by seeing the program

2 Answers   DELL,


What are the bind parameters ibm db2?

0 Answers  


what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx

2 Answers   IBM,


How do I change the column size in db2?

0 Answers  


what is the input to PLAN? what is the input to DBRM?

4 Answers  


What is the SQL Communications Area and what are some of its key fields?

1 Answers  


Categories