Interview Questions   Tutorials   Discussions   Programs   

DB2 - What is an inner join, and an outer join ?




331
views
asked mar August 3, 2014 06:57 AM  

What is an inner join, and an outer join ?


           

1 Answers



 
answered By Mswami   0  
Inner Join: combine information from two or more tables by comparing all values that meet the search criteria in the designated column or columns of one table with all the values in corresponding columns of the other table or tables.  This kind of join which involve a match in both columns are called inner joins.

Outer join: Is one in which you want both matching and non matching rows to be returned. DB2 has no specific operator for outer joins, it can be simulated by combining a join and a correlated sub query with a UNION.



 
flag   
   add comment

Your answer

Join with account you already have

FF

Preview

 Write A Tutorials
Online-Classroom Classes
www.writeabc.com


  1 person following this question

  1 person following this tag

  Question tags

Asked 2 years and 3 months ago ago
Number of Views -331
Number of Answers -1
Last updated
3 years and 4 months ago ago

Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert