What is an inner join, and an outer join?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is an inner join, and an outer join?

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

(Continued on next question...)

Other Job Interview Questions

• What does it mean if the null indicator has -1, 0, -2??
• How will you delete duplicate records from a table ?
• What is auditing
• What is an alias and how does it differ from a synonym?
• What are the four lockable units for DB2?
• How many buffer pools are available in DB2
• What are foreign keys?
• What will the COMMIT accomplish?
• What is normalization and what are the five normal forms?
• How would you print the output of an SQL statement from SPUFI?
• More...